/*
Navicat MySQL Data Transfer

Source Server         : 112.121.184.226
Source Server Version : 50022
Source Host           : 112.121.184.226:3306
Source Database       : sq_916178

Target Server Type    : MYSQL
Target Server Version : 50022
File Encoding         : 65001

Date: 2011-04-14 16:56:46
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `thx_ad`
-- ----------------------------
DROP TABLE IF EXISTS `thx_ad`;
CREATE TABLE `thx_ad` (
`adid`  smallint(6) UNSIGNED NOT NULL AUTO_INCREMENT ,
`available`  tinyint(1) NOT NULL DEFAULT 1 ,
`title`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`pagetype`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`adcode`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`system`  tinyint(1) NOT NULL DEFAULT 0 ,
PRIMARY KEY (`adid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_ad
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_adminsession`
-- ----------------------------
DROP TABLE IF EXISTS `thx_adminsession`;
CREATE TABLE `thx_adminsession` (
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`ip`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`errorcount`  tinyint(1) NOT NULL DEFAULT 0 ,
PRIMARY KEY (`uid`)
)
ENGINE=MEMORY
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_adminsession
-- ----------------------------
BEGIN;
INSERT INTO thx_adminsession VALUES ('1', '113.108.110.50', '1302674946', '-1');
COMMIT;

-- ----------------------------
-- Table structure for `thx_album`
-- ----------------------------
DROP TABLE IF EXISTS `thx_album`;
CREATE TABLE `thx_album` (
`albumid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`albumname`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`updatetime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`picnum`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`pic`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`picflag`  tinyint(1) NOT NULL DEFAULT 0 ,
`friend`  tinyint(1) NOT NULL DEFAULT 0 ,
`password`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`target_ids`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`albumid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_album
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_appcreditlog`
-- ----------------------------
DROP TABLE IF EXISTS `thx_appcreditlog`;
CREATE TABLE `thx_appcreditlog` (
`logid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`appid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`appname`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`type`  tinyint(1) NOT NULL DEFAULT 0 ,
`credit`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`note`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`logid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_appcreditlog
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_blacklist`
-- ----------------------------
DROP TABLE IF EXISTS `thx_blacklist`;
CREATE TABLE `thx_blacklist` (
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`buid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`uid`, `buid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_blacklist
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_block`
-- ----------------------------
DROP TABLE IF EXISTS `thx_block`;
CREATE TABLE `thx_block` (
`bid`  smallint(6) UNSIGNED NOT NULL AUTO_INCREMENT ,
`blockname`  varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`blocksql`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`cachename`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`cachetime`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`startnum`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`num`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`perpage`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`htmlcode`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`bid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_block
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_blog`
-- ----------------------------
DROP TABLE IF EXISTS `thx_blog`;
CREATE TABLE `thx_blog` (
`blogid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`topicid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`subject`  char(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`classid`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`viewnum`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`replynum`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`hot`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`pic`  char(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`picflag`  tinyint(1) NOT NULL DEFAULT 0 ,
`noreply`  tinyint(1) NOT NULL DEFAULT 0 ,
`friend`  tinyint(1) NOT NULL DEFAULT 0 ,
`password`  char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`click_1`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`click_2`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`click_3`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`click_4`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`click_5`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`type`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'blog' COMMENT '种类' ,
PRIMARY KEY (`blogid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=17

;

-- ----------------------------
-- Records of thx_blog
-- ----------------------------
BEGIN;
INSERT INTO thx_blog VALUES ('1', '0', '1', 'admin', '这是第一条日志', '1', '0', '0', '0', '1302485496', 'attachment/201104/11/1_130248566376dx.jpg', '0', '0', '0', '', '0', '0', '0', '0', '0', 'blog'), ('2', '0', '1', 'admin', '动态2', '1', '0', '0', '0', '1302488312', '', '0', '0', '0', '', '0', '0', '0', '0', '0', 'blog'), ('3', '0', '1', 'admin', '哒哒哒', '1', '0', '0', '0', '1302489676', '', '0', '0', '0', '', '0', '0', '0', '0', '0', 'blog'), ('4', '0', '1', 'admin', '对方答复的', '1', '0', '0', '0', '1302490513', '', '0', '0', '0', '', '0', '0', '0', '0', '0', 'blog'), ('5', '0', '1', 'admin', '防对方答复对方', '1', '0', '0', '0', '1302490521', '', '0', '0', '0', '', '0', '0', '0', '0', '0', 'blog'), ('6', '0', '1', 'admin', '答复对方答复', '1', '0', '0', '0', '1302490531', '', '0', '0', '0', '', '0', '0', '0', '0', '0', 'blog'), ('7', '0', '1', 'admin', '单打独斗', '1', '0', '0', '0', '1302490536', '', '0', '0', '0', '', '0', '0', '0', '0', '0', 'blog'), ('8', '0', '1', 'admin', '对方答复的', '1', '0', '0', '0', '1302490542', '', '0', '0', '0', '', '0', '0', '0', '0', '0', 'blog'), ('9', '0', '1', 'admin', '答复对方答复大幅', '1', '0', '0', '0', '1302490548', '', '0', '0', '0', '', '0', '0', '0', '0', '0', 'blog'), ('10', '0', '1', 'admin', '中国国务院新闻办公室10日发表《2010年美国的人权纪录》，以回应美国国务院8日发表的《2', '1', '0', '0', '0', '1302490553', '201104/11/1_1302500719JPe9.jpg.thumb.jpg', '1', '0', '0', '', '0', '0', '0', '0', '0', 'blog'), ('11', '0', '1', 'admin', '单打独斗', '1', '0', '0', '0', '1302490558', '', '0', '0', '0', '', '0', '0', '0', '0', '0', 'blog'), ('12', '0', '1', 'admin', '知识分类你好', '2', '0', '0', '0', '1302497281', 'attachment/201104/12/1_13026147412i4i.jpg', '0', '0', '0', '', '0', '0', '0', '0', '0', 'cpzs'), ('13', '0', '1', 'admin', '服务', '3', '0', '0', '0', '1302498380', '', '0', '0', '0', '', '0', '0', '0', '0', '0', 'ppfw'), ('14', '0', '1', 'admin', '服务分类2', '4', '0', '0', '0', '1302498891', '', '0', '0', '0', '', '0', '0', '0', '0', '0', 'ppfw'), ('15', '0', '1', 'admin', '的是否适当方式的', '3', '0', '0', '0', '1302499112', '', '0', '0', '0', '', '0', '0', '0', '0', '0', 'ppfw'), ('16', '0', '1', 'admin', '哈哈哈', '2', '0', '0', '0', '1302625363', 'attachment/201104/12/1_13026147412i4i.jpg', '0', '0', '0', '', '0', '0', '0', '0', '0', 'cpzs');
COMMIT;

-- ----------------------------
-- Table structure for `thx_blogfield`
-- ----------------------------
DROP TABLE IF EXISTS `thx_blogfield`;
CREATE TABLE `thx_blogfield` (
`blogid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`tag`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`message`  mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`postip`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`related`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`relatedtime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`target_ids`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`hotuser`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`magiccolor`  tinyint(6) NOT NULL DEFAULT 0 ,
`magicpaper`  tinyint(6) NOT NULL DEFAULT 0 ,
`magiccall`  tinyint(1) NOT NULL DEFAULT 0 ,
PRIMARY KEY (`blogid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_blogfield
-- ----------------------------
BEGIN;
INSERT INTO thx_blogfield VALUES ('1', '1', 'a:1:{i:1;s:6:\"日志\";}', '<p class=\"first\">中国国务院新闻办公室10日发表《2010年美国的人权纪录》，以回应美国国务院8日发表的《2010年国别人权报告》对中国人权状况的指责。</p>\r\n<p>这是国务院新闻办公室针对美国一年一度的国别人权报告连续第12年发表美国的人权纪录，目的在于“敦促美国正视自身的人权问题”。《2010年美国的人权纪录》指出，美国国务院发表《2010年国别人权报告》，再次对包括中国在内的世界190多个国家和地区的人权状况进行歪曲指责，却对自身糟糕的人权状况熟视无睹，很少提及。</p>\r\n<p>《2010年美国的人权纪录》全文约1.3万字，包括关于生命、财产和人身安全，关于公民权利和政治权利，关于经济、社会、文化权利，关于种族歧视，关于妇女和儿童权利，关于侵犯他国人权等6个部分。</p>\r\n<p>人权纪录指出，美国是世界上暴力犯罪最严重的国家，公民的生命、财产和人身安全得不到应有的保障。美国每年约有1/5的人成为各种犯罪行为的受害者，这一比例居全世界之首。美国枪支管理松懈，泛滥成灾。枪杀事件高发，血案不断。</p>\r\n<p>人权纪录称，美国政府侵犯公民权利和政治权利的情况相当严重。公民隐私遭到侵犯。美国公民自由联盟2010年9月公布的数据显示，2008年10月1日到2010年6月2日，有超过6600名游客在港口过境处遭受电子设备搜查，其中近一半是美国公民。警察滥施暴力和刑讯逼供现象严重。美国一向自诩“自由的乐土”，但是美国被剥夺自由的囚犯数量居世界之最。美国冤案错案频发。美国一向以“民主的灯塔”自居，而实际上，美国的民主是金</p><div class=\"uchome-message-pic\"><img src=\"attachment/201104/11/1_130248566376dx.jpg\"><p></p></div><div class=\"uchome-message-pic\"><img src=\"attachment/201104/11/1_13024857141wrg.jpg\"><p></p></div>', '127.0.0.1', 'a:0:{}', '1302485496', '', '', '0', '0', '0'), ('2', '1', '', '<p class=\"first\">中国国务院新闻办公室10日发表《2010年美国的人权纪录》，以回应美国国务院8日发表的《2010年国别人权报告》对中国人权状况的指责。</p>\r\n<p>这是国务院新闻办公室针对美国一年一度的国别人权报告连续第12年发表美国的人权纪录，目的在于“敦促美国正视自身的人权问题”。《2010年美国的人权纪录》指出，美国国务院发表《2010年国别人权报告》，再次对包括中国在内的世界190多个国家和地区的人权状况进行歪曲指责，却对自身糟糕的人权状况熟视无睹，很少提及。</p>\r\n<p>《2010年美国的人权纪录》全文约1.3万字，包括关于生命、财产和人身安全，关于公民权利和政治权利，关于经济、社会、文化权利，关于种族歧视，关于妇女和儿童权利，关于侵犯他国人权等6个部分。</p>\r\n<p>人权纪录指出，美国是世界上暴力犯罪最严重的国家，公民的生命、财产和人身安全得不到应有的保障。美国每年约有1/5的人成为各种犯罪行为的受害者，这一比例居全世界之首。美国枪支管理松懈，泛滥成灾。枪杀事件高发，血案不断。</p>\r\n<p>人权纪录称，美国政府侵犯公民权利和政治权利的情况相当严重。公民隐私遭到侵犯。美国公民自由联盟2010年9月公布的数据显示，2008年10月1日到2010年6月2日，有超过6600名游客在港口过境处遭受电子设备搜查，其中近一半是美国公民。警察滥施暴力和刑讯逼供现象严重。美国一向自诩“自由的乐土”，但是美国被剥夺自由的囚犯数量居世界之最。美国冤案错案频发。美国一向以“民主的灯塔”自居，而实际上，美国的民主是金</p>', '127.0.0.1', '', '0', '', '', '0', '0', '0'), ('3', '1', '', '中国国务院新闻办公室10日发表《2010年美国的人权纪录》，以回应美国国务院8日发表的《2010年国别人权报告》对中国人权状况的指责。<br><br>这是国务院新闻办公室针对美国一年一度的国别人权报告连续第12年发表美国的人权纪录，目的在于“敦促美国正视自身的人权问题”。《2010年美国的人权纪录》指出，美国国务院发表《2010年国别人权报告》，再次对包括中国在内的世界190多个国家和地区的人权状况进行歪曲指责，却对自身糟糕的人权状况熟视无睹，很少提及。<br><br>《2010年美国的人权纪录》全文约1.3万字，包括关于生命、财产和人身安全，关于公民权利和政治权利，关于经济、社会、文化权利，关于种族歧视，关于妇女和儿童权利，关于侵犯他国人权等6个部分。<br><br>人权纪录指出，美国是世界上暴力犯罪最严重的国家，公民的生命、财产和人身安全得不到应有的保障。美国每年约有1/5的人成为各种犯罪行为的受害者，这一比例居全世界之首。美国枪支管理松懈，泛滥成灾。枪杀事件高发，血案不断。<br><br>人权纪录称，美国政府侵犯公民权利和政治权利的情况相当严重。公民隐私遭到侵犯。美国公民自由联盟2010年9月公布的数据显示，2008年10月1日到 2010年6月2日，有超过6600名游客在港口过境处遭受电子设备搜查，其中近一半是美国公民。警察滥施暴力和刑讯逼供现象严重。美国一向自诩“自由的乐土”，但是美国被剥夺自由的囚犯数量居世界之最。美国冤案错案频发。美国一向以“民主的灯塔”自居，而实际上，美国的民主是金', '127.0.0.1', '', '0', '', '', '0', '0', '0'), ('4', '1', '', '中国国务院新闻办公室10日发表《2010年美国的人权纪录》，以回应美国国务院8日发表的《2010年国别人权报告》对中国人权状况的指责。<br><br>这是国务院新闻办公室针对美国一年一度的国别人权报告连续第12年发表美国的人权纪录，目的在于“敦促美国正视自身的人权问题”。《2010年美国的人权纪录》指出，美国国务院发表《2010年国别人权报告》，再次对包括中国在内的世界190多个国家和地区的人权状况进行歪曲指责，却对自身糟糕的人权状况熟视无睹，很少提及。<br><br>《2010年美国的人权纪录》全文约1.3万字，包括关于生命、财产和人身安全，关于公民权利和政治权利，关于经济、社会、文化权利，关于种族歧视，关于妇女和儿童权利，关于侵犯他国人权等6个部分。<br><br>人权纪录指出，美国是世界上暴力犯罪最严重的国家，公民的生命、财产和人身安全得不到应有的保障。美国每年约有1/5的人成为各种犯罪行为的受害者，这一比例居全世界之首。美国枪支管理松懈，泛滥成灾。枪杀事件高发，血案不断。<br><br>人权纪录称，美国政府侵犯公民权利和政治权利的情况相当严重。公民隐私遭到侵犯。美国公民自由联盟2010年9月公布的数据显示，2008年10月1日到 2010年6月2日，有超过6600名游客在港口过境处遭受电子设备搜查，其中近一半是美国公民。警察滥施暴力和刑讯逼供现象严重。美国一向自诩“自由的乐土”，但是美国被剥夺自由的囚犯数量居世界之最。美国冤案错案频发。美国一向以“民主的灯塔”自居，而实际上，美国的民主是金', '127.0.0.1', '', '0', '', '', '0', '0', '0'), ('5', '1', '', '中国国务院新闻办公室10日发表《2010年美国的人权纪录》，以回应美国国务院8日发表的《2010年国别人权报告》对中国人权状况的指责。<br><br>这是国务院新闻办公室针对美国一年一度的国别人权报告连续第12年发表美国的人权纪录，目的在于“敦促美国正视自身的人权问题”。《2010年美国的人权纪录》指出，美国国务院发表《2010年国别人权报告》，再次对包括中国在内的世界190多个国家和地区的人权状况进行歪曲指责，却对自身糟糕的人权状况熟视无睹，很少提及。<br><br>《2010年美国的人权纪录》全文约1.3万字，包括关于生命、财产和人身安全，关于公民权利和政治权利，关于经济、社会、文化权利，关于种族歧视，关于妇女和儿童权利，关于侵犯他国人权等6个部分。<br><br>人权纪录指出，美国是世界上暴力犯罪最严重的国家，公民的生命、财产和人身安全得不到应有的保障。美国每年约有1/5的人成为各种犯罪行为的受害者，这一比例居全世界之首。美国枪支管理松懈，泛滥成灾。枪杀事件高发，血案不断。<br><br>人权纪录称，美国政府侵犯公民权利和政治权利的情况相当严重。公民隐私遭到侵犯。美国公民自由联盟2010年9月公布的数据显示，2008年10月1日到 2010年6月2日，有超过6600名游客在港口过境处遭受电子设备搜查，其中近一半是美国公民。警察滥施暴力和刑讯逼供现象严重。美国一向自诩“自由的乐土”，但是美国被剥夺自由的囚犯数量居世界之最。美国冤案错案频发。美国一向以“民主的灯塔”自居，而实际上，美国的民主是金', '127.0.0.1', '', '0', '', '', '0', '0', '0'), ('6', '1', '', '中国国务院新闻办公室10日发表《2010年美国的人权纪录》，以回应美国国务院8日发表的《2010年国别人权报告》对中国人权状况的指责。<br><br>这是国务院新闻办公室针对美国一年一度的国别人权报告连续第12年发表美国的人权纪录，目的在于“敦促美国正视自身的人权问题”。《2010年美国的人权纪录》指出，美国国务院发表《2010年国别人权报告》，再次对包括中国在内的世界190多个国家和地区的人权状况进行歪曲指责，却对自身糟糕的人权状况熟视无睹，很少提及。<br><br>《2010年美国的人权纪录》全文约1.3万字，包括关于生命、财产和人身安全，关于公民权利和政治权利，关于经济、社会、文化权利，关于种族歧视，关于妇女和儿童权利，关于侵犯他国人权等6个部分。<br><br>人权纪录指出，美国是世界上暴力犯罪最严重的国家，公民的生命、财产和人身安全得不到应有的保障。美国每年约有1/5的人成为各种犯罪行为的受害者，这一比例居全世界之首。美国枪支管理松懈，泛滥成灾。枪杀事件高发，血案不断。<br><br>人权纪录称，美国政府侵犯公民权利和政治权利的情况相当严重。公民隐私遭到侵犯。美国公民自由联盟2010年9月公布的数据显示，2008年10月1日到 2010年6月2日，有超过6600名游客在港口过境处遭受电子设备搜查，其中近一半是美国公民。警察滥施暴力和刑讯逼供现象严重。美国一向自诩“自由的乐土”，但是美国被剥夺自由的囚犯数量居世界之最。美国冤案错案频发。美国一向以“民主的灯塔”自居，而实际上，美国的民主是金', '127.0.0.1', '', '0', '', '', '0', '0', '0'), ('7', '1', '', '中国国务院新闻办公室10日发表《2010年美国的人权纪录》，以回应美国国务院8日发表的《2010年国别人权报告》对中国人权状况的指责。<br><br>这是国务院新闻办公室针对美国一年一度的国别人权报告连续第12年发表美国的人权纪录，目的在于“敦促美国正视自身的人权问题”。《2010年美国的人权纪录》指出，美国国务院发表《2010年国别人权报告》，再次对包括中国在内的世界190多个国家和地区的人权状况进行歪曲指责，却对自身糟糕的人权状况熟视无睹，很少提及。<br><br>《2010年美国的人权纪录》全文约1.3万字，包括关于生命、财产和人身安全，关于公民权利和政治权利，关于经济、社会、文化权利，关于种族歧视，关于妇女和儿童权利，关于侵犯他国人权等6个部分。<br><br>人权纪录指出，美国是世界上暴力犯罪最严重的国家，公民的生命、财产和人身安全得不到应有的保障。美国每年约有1/5的人成为各种犯罪行为的受害者，这一比例居全世界之首。美国枪支管理松懈，泛滥成灾。枪杀事件高发，血案不断。<br><br>人权纪录称，美国政府侵犯公民权利和政治权利的情况相当严重。公民隐私遭到侵犯。美国公民自由联盟2010年9月公布的数据显示，2008年10月1日到 2010年6月2日，有超过6600名游客在港口过境处遭受电子设备搜查，其中近一半是美国公民。警察滥施暴力和刑讯逼供现象严重。美国一向自诩“自由的乐土”，但是美国被剥夺自由的囚犯数量居世界之最。美国冤案错案频发。美国一向以“民主的灯塔”自居，而实际上，美国的民主是金', '127.0.0.1', '', '0', '', '', '0', '0', '0'), ('8', '1', '', '答复对方答复中国国务院新闻办公室10日发表《2010年美国的人权纪录》，以回应美国国务院8日发表的《2010年国别人权报告》对中国人权状况的指责。<br><br>这是国务院新闻办公室针对美国一年一度的国别人权报告连续第12年发表美国的人权纪录，目的在于“敦促美国正视自身的人权问题”。《2010年美国的人权纪录》指出，美国国务院发表《2010年国别人权报告》，再次对包括中国在内的世界190多个国家和地区的人权状况进行歪曲指责，却对自身糟糕的人权状况熟视无睹，很少提及。<br><br>《2010年美国的人权纪录》全文约1.3万字，包括关于生命、财产和人身安全，关于公民权利和政治权利，关于经济、社会、文化权利，关于种族歧视，关于妇女和儿童权利，关于侵犯他国人权等6个部分。<br><br>人权纪录指出，美国是世界上暴力犯罪最严重的国家，公民的生命、财产和人身安全得不到应有的保障。美国每年约有1/5的人成为各种犯罪行为的受害者，这一比例居全世界之首。美国枪支管理松懈，泛滥成灾。枪杀事件高发，血案不断。<br><br>人权纪录称，美国政府侵犯公民权利和政治权利的情况相当严重。公民隐私遭到侵犯。美国公民自由联盟2010年9月公布的数据显示，2008年10月1日到 2010年6月2日，有超过6600名游客在港口过境处遭受电子设备搜查，其中近一半是美国公民。警察滥施暴力和刑讯逼供现象严重。美国一向自诩“自由的乐土”，但是美国被剥夺自由的囚犯数量居世界之最。美国冤案错案频发。美国一向以“民主的灯塔”自居，而实际上，美国的民主是金', '127.0.0.1', '', '0', '', '', '0', '0', '0'), ('9', '1', '', '答复对方答复大幅中国国务院新闻办公室10日发表《2010年美国的人权纪录》，以回应美国国务院8日发表的《2010年国别人权报告》对中国人权状况的指责。<br><br>这是国务院新闻办公室针对美国一年一度的国别人权报告连续第12年发表美国的人权纪录，目的在于“敦促美国正视自身的人权问题”。《2010年美国的人权纪录》指出，美国国务院发表《2010年国别人权报告》，再次对包括中国在内的世界190多个国家和地区的人权状况进行歪曲指责，却对自身糟糕的人权状况熟视无睹，很少提及。<br><br>《2010年美国的人权纪录》全文约1.3万字，包括关于生命、财产和人身安全，关于公民权利和政治权利，关于经济、社会、文化权利，关于种族歧视，关于妇女和儿童权利，关于侵犯他国人权等6个部分。<br><br>人权纪录指出，美国是世界上暴力犯罪最严重的国家，公民的生命、财产和人身安全得不到应有的保障。美国每年约有1/5的人成为各种犯罪行为的受害者，这一比例居全世界之首。美国枪支管理松懈，泛滥成灾。枪杀事件高发，血案不断。<br><br>人权纪录称，美国政府侵犯公民权利和政治权利的情况相当严重。公民隐私遭到侵犯。美国公民自由联盟2010年9月公布的数据显示，2008年10月1日到 2010年6月2日，有超过6600名游客在港口过境处遭受电子设备搜查，其中近一半是美国公民。警察滥施暴力和刑讯逼供现象严重。美国一向自诩“自由的乐土”，但是美国被剥夺自由的囚犯数量居世界之最。美国冤案错案频发。美国一向以“民主的灯塔”自居，而实际上，美国的民主是金', '127.0.0.1', '', '0', '', '', '0', '0', '0'), ('10', '1', '', '中国国务院新闻办公室10日发表《2010年美国的人权纪录》，以回应美国国务院8日发表的《2010年国别人权报告》对中国人权状况的指责。<br><br>这是国务院新闻办公室针对美国一年一度的国别人权报告连续第12年发表美国的人权纪录，目的在于“敦促美国正视自身的人权问题”。《2010年美国的人权纪录》指出，美国国务院发表《2010年国别人权报告》，再次对包括中国在内的世界190多个国家和地区的人权状况进行歪曲指责，却对自身糟糕的人权状况熟视无睹，很少提及。<br><br>《2010年美国的人权纪录》全文约1.3万字，包括关于生命、财产和人身安全，关于公民权利和政治权利，关于经济、社会、文化权利，关于种族歧视，关于妇女和儿童权利，关于侵犯他国人权等6个部分。<br><br>人权纪录指出，美国是世界上暴力犯罪最严重的国家，公民的生命、财产和人身安全得不到应有的保障。美国每年约有1/5的人成为各种犯罪行为的受害者，这一比例居全世界之首。美国枪支管理松懈，泛滥成灾。枪杀事件高发，血案不断。<br><br>人权纪录称，美国政府侵犯公民权利和政治权利的情况相当严重。公民隐私遭到侵犯。美国公民自由联盟2010年9月公布的数据显示，2008年10月1日到 2010年6月2日，有超过6600名游客在港口过境处遭受电子设备搜查，其中近一半是美国公民。警察滥施暴力和刑讯逼供现象严重。美国一向自诩“自由的乐土”，但是美国被剥夺自由的囚犯数量居世界之最。美国冤案错案频发。美国一向以“民主的灯塔”自居，而实际上，美国的民主是金<div class=\"uchome-message-pic\"><img src=\"attachment/201104/11/1_1302500719JPe9.jpg\"><p></p></div><div class=\"uchome-message-pic\"><img src=\"attachment/201104/11/1_13025007191Vv1.jpg\"><p></p></div>', '127.0.0.1', '', '0', '', '', '0', '0', '0'), ('11', '1', 'a:2:{i:2;s:6:\"单打\";i:3;s:6:\"独斗\";}', '中国国务院新闻办公室10日发表《2010年美国的人权纪录》，以回应美国国务院8日发表的《2010年国别人权报告》对中国人权状况的指责。<br><br>这是国务院新闻办公室针对美国一年一度的国别人权报告连续第12年发表美国的人权纪录，目的在于“敦促美国正视自身的人权问题”。《2010年美国的人权纪录》指出，美国国务院发表《2010年国别人权报告》，再次对包括中国在内的世界190多个国家和地区的人权状况进行歪曲指责，却对自身糟糕的人权状况熟视无睹，很少提及。<br><br>《2010年美国的人权纪录》全文约1.3万字，包括关于生命、财产和人身安全，关于公民权利和政治权利，关于经济、社会、文化权利，关于种族歧视，关于妇女和儿童权利，关于侵犯他国人权等6个部分。<br><br>人权纪录指出，美国是世界上暴力犯罪最严重的国家，公民的生命、财产和人身安全得不到应有的保障。美国每年约有1/5的人成为各种犯罪行为的受害者，这一比例居全世界之首。美国枪支管理松懈，泛滥成灾。枪杀事件高发，血案不断。<br><br>人权纪录称，美国政府侵犯公民权利和政治权利的情况相当严重。公民隐私遭到侵犯。美国公民自由联盟2010年9月公布的数据显示，2008年10月1日到 2010年6月2日，有超过6600名游客在港口过境处遭受电子设备搜查，其中近一半是美国公民。警察滥施暴力和刑讯逼供现象严重。美国一向自诩“自由的乐土”，但是美国被剥夺自由的囚犯数量居世界之最。美国冤案错案频发。美国一向以“民主的灯塔”自居，而实际上，美国的民主是金', '127.0.0.1', 'a:0:{}', '1302601512', '', '', '0', '0', '0'), ('12', '1', '', '知识分类知识分类知识分类知识分类知识分类知识分类知识分类<br>\r\n<br>\r\n<br>\r\n知识分类知识分类知识分类知识分类知识分类知识分类知识分类<br>\r\n<br>\r\n<br>\r\n知识分类知识分类知识分类知识分类知识分类知识分类知识分类<br>\r\n<br>\r\n<br>\r\n知识分类知识分类知识分类知识分类知识分类知识分类知识分类<br>\r\n<br>\r\n<br>\r\n知识分类知识分类知识分类知识分类知识分类知识分类知识分类<br>\r\n你好<br>\r\n<br>\r\n知识分类知识分类知识分类知识分类知识分类知识分类知识分类<br>\r\n<br>\r\n<br>\r\n知识分类知识分类知识分类知识分类知识分类知识分类知识分类<br>\r\n<br>\r\n<br>\r\n知识分类知识分类知识分类知识分类知识分类知识分类知识分类<br>\r\n<br>\r\n<br>\r\n知识分类知识分类知识分类知识分类知识分类知识分类知识分类<br>\r\n<br>\r\n<br><div class=\"uchome-message-pic\"><img src=\"attachment/201104/12/1_13026147412i4i.jpg\"><p></p></div>', '183.13.179.151', '', '0', '', '', '0', '0', '0'), ('13', '1', '', '哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒哒', '127.0.0.1', '', '0', '', '', '0', '0', '0'), ('14', '1', '', '服务分类服务分类服务分类服务分类服务分类服务分类服务分类服务分类服务分类服务分类服务分类服务分类服务分类服务分类服务分类服务分类服务分类服务分类', '127.0.0.1', '', '0', '', '', '0', '0', '0'), ('15', '1', '', '上的发生的发生的上的发生的发生的上的发生的发生的上的发生的发生的上的发生的发生的上的发生的发生的上的发生的发生的上的发生的发生的上的发生的发生的上的发生的发生的<br><br>上的发生的发生的上的发生的发生的上的发生的发生的上的发生的发生的上的发生的发生的上的发生的发生的上的发生的发生的上的发生的发生的上的发生的发生的上的发生的发生的上的发生的发生的上的发生的发生的', '127.0.0.1', '', '0', '', '', '0', '0', '0'), ('16', '1', '', '<p><img src=\"attachment/201104/12/1_13026147412i4i.jpg\">哈哈哈</p>', '183.13.179.151', '', '0', '', '', '0', '0', '0');
COMMIT;

-- ----------------------------
-- Table structure for `thx_cache`
-- ----------------------------
DROP TABLE IF EXISTS `thx_cache`;
CREATE TABLE `thx_cache` (
`cachekey`  varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`value`  mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`mtime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`cachekey`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_cache
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_class`
-- ----------------------------
DROP TABLE IF EXISTS `thx_class`;
CREATE TABLE `thx_class` (
`classid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`classname`  char(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`type`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'blog' ,
PRIMARY KEY (`classid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=5

;

-- ----------------------------
-- Records of thx_class
-- ----------------------------
BEGIN;
INSERT INTO thx_class VALUES ('1', '动态1', '1', '1302485496', 'blog'), ('2', '知识1', '1', '1302497281', 'cpzs'), ('3', '分类1', '1', '1302498380', 'ppfw'), ('4', '分类2', '1', '1302498891', 'ppfw');
COMMIT;

-- ----------------------------
-- Table structure for `thx_click`
-- ----------------------------
DROP TABLE IF EXISTS `thx_click`;
CREATE TABLE `thx_click` (
`clickid`  smallint(6) UNSIGNED NOT NULL AUTO_INCREMENT ,
`name`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`icon`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`idtype`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`displayorder`  tinyint(6) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`clickid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=16

;

-- ----------------------------
-- Records of thx_click
-- ----------------------------
BEGIN;
INSERT INTO thx_click VALUES ('1', '路过', 'luguo.gif', 'blogid', '0'), ('2', '雷人', 'leiren.gif', 'blogid', '0'), ('3', '握手', 'woshou.gif', 'blogid', '0'), ('4', '鲜花', 'xianhua.gif', 'blogid', '0'), ('5', '鸡蛋', 'jidan.gif', 'blogid', '0'), ('6', '漂亮', 'piaoliang.gif', 'picid', '0'), ('7', '酷毙', 'kubi.gif', 'picid', '0'), ('8', '雷人', 'leiren.gif', 'picid', '0'), ('9', '鲜花', 'xianhua.gif', 'picid', '0'), ('10', '鸡蛋', 'jidan.gif', 'picid', '0'), ('11', '搞笑', 'gaoxiao.gif', 'tid', '0'), ('12', '迷惑', 'mihuo.gif', 'tid', '0'), ('13', '雷人', 'leiren.gif', 'tid', '0'), ('14', '鲜花', 'xianhua.gif', 'tid', '0'), ('15', '鸡蛋', 'jidan.gif', 'tid', '0');
COMMIT;

-- ----------------------------
-- Table structure for `thx_clickuser`
-- ----------------------------
DROP TABLE IF EXISTS `thx_clickuser`;
CREATE TABLE `thx_clickuser` (
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`id`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`idtype`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`clickid`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_clickuser
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_comment`
-- ----------------------------
DROP TABLE IF EXISTS `thx_comment`;
CREATE TABLE `thx_comment` (
`cid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`id`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`idtype`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`authorid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`author`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`ip`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`message`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`magicflicker`  tinyint(1) NOT NULL DEFAULT 0 ,
PRIMARY KEY (`cid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_comment
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_config`
-- ----------------------------
DROP TABLE IF EXISTS `thx_config`;
CREATE TABLE `thx_config` (
`var`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`datavalue`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`var`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_config
-- ----------------------------
BEGIN;
INSERT INTO thx_config VALUES ('sitename', '林慧轩'), ('template', 'blue'), ('adminemail', 'webmaster@www.916178.com'), ('onlinehold', '1800'), ('timeoffset', '8'), ('maxpage', '100'), ('starcredit', '100'), ('starlevelnum', '5'), ('cachemode', 'database'), ('cachegrade', '0'), ('allowcache', '1'), ('allowdomain', '0'), ('allowrewrite', '0'), ('allowwatermark', '0'), ('allowftp', '0'), ('holddomain', 'www|*blog*|*space*|x'), ('mtagminnum', '5'), ('feedday', '7'), ('feedmaxnum', '100'), ('feedfilternum', '10'), ('importnum', '100'), ('maxreward', '10'), ('singlesent', '50'), ('groupnum', '8'), ('closeregister', '1'), ('closeinvite', '1'), ('close', '0'), ('networkpublic', '1'), ('networkpage', '1'), ('seccode_register', '1'), ('uc_tagrelated', '1'), ('manualmoderator', '1'), ('linkguide', '0'), ('showall', '1'), ('sendmailday', '0'), ('realname', '0'), ('namecheck', '0'), ('namechange', '0'), ('name_allowviewspace', '1'), ('name_allowfriend', '1'), ('name_allowpoke', '1'), ('name_allowdoing', '1'), ('name_allowblog', '0'), ('name_allowalbum', '0'), ('name_allowthread', '0'), ('name_allowshare', '0'), ('name_allowcomment', '0'), ('name_allowpost', '0'), ('showallfriendnum', '10'), ('feedtargetblank', '1'), ('feedread', '1'), ('feedhotnum', '3'), ('feedhotday', '2'), ('feedhotmin', '3'), ('feedhiddenicon', 'friend,profile,task,wall'), ('uc_tagrelatedtime', '86400'), ('privacy', 'a:2:{s:4:\"view\";a:12:{s:5:\"index\";i:0;s:7:\"profile\";i:0;s:6:\"friend\";i:0;s:4:\"wall\";i:0;s:4:\"feed\";i:0;s:4:\"mtag\";i:0;s:5:\"event\";i:0;s:5:\"doing\";i:0;s:4:\"blog\";i:0;s:5:\"album\";i:0;s:5:\"share\";i:0;s:4:\"poll\";i:0;}s:4:\"feed\";a:21:{s:5:\"doing\";i:1;s:4:\"blog\";i:1;s:6:\"upload\";i:1;s:5:\"share\";i:1;s:4:\"poll\";i:1;s:8:\"joinpoll\";i:1;s:6:\"thread\";i:1;s:4:\"post\";i:1;s:4:\"mtag\";i:1;s:5:\"event\";i:1;s:4:\"join\";i:1;s:6:\"friend\";i:1;s:7:\"comment\";i:1;s:4:\"show\";i:1;s:9:\"spaceopen\";i:1;s:6:\"credit\";i:1;s:6:\"invite\";i:1;s:4:\"task\";i:1;s:7:\"profile\";i:1;s:5:\"album\";i:1;s:5:\"click\";i:1;}}'), ('cronnextrun', '1302703800'), ('my_status', '0'), ('uniqueemail', '1'), ('updatestat', '1'), ('my_showgift', '1'), ('topcachetime', '60'), ('newspacenum', '3'), ('sitekey', '17603aCljkPxn6X5'), ('siteallurl', 'http://www.916178.com/thx/'), ('licensed', '0'), ('debuginfo', '0'), ('miibeian', ''), ('headercharset', '0'), ('avatarreal', '0'), ('uc_dir', ''), ('my_ip', ''), ('closereason', ''), ('checkemail', '0'), ('regipdate', ''), ('my_closecheckupdate', '0'), ('openxmlrpc', '0'), ('domainroot', ''), ('name_allowpoll', '0'), ('name_allowevent', '0'), ('name_allowuserapp', '0'), ('video_allowviewphoto', '0'), ('video_allowfriend', '0'), ('video_allowpoke', '0'), ('video_allowwall', '0'), ('video_allowcomment', '0'), ('video_allowdoing', '0'), ('video_allowblog', '0'), ('video_allowalbum', '0'), ('video_allowthread', '0'), ('video_allowpoll', '0'), ('video_allowevent', '0'), ('video_allowshare', '0'), ('video_allowpost', '0'), ('video_allowuserapp', '0'), ('ftpurl', ''), ('newspaceavatar', '0'), ('newspacerealname', '0'), ('newspacevideophoto', '0'), ('login_action', '');
INSERT INTO thx_config VALUES ('register_action', ''), ('seccode_login', '1'), ('questionmode', '0'), ('need_email', '0'), ('newusertime', ''), ('need_avatar', '0'), ('need_friendnum', '');
COMMIT;

-- ----------------------------
-- Table structure for `thx_creditlog`
-- ----------------------------
DROP TABLE IF EXISTS `thx_creditlog`;
CREATE TABLE `thx_creditlog` (
`clid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`rid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`total`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`cyclenum`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`credit`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`experience`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`starttime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`info`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`user`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`app`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`clid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=5

;

-- ----------------------------
-- Records of thx_creditlog
-- ----------------------------
BEGIN;
INSERT INTO thx_creditlog VALUES ('1', '1', '1', '1', '1', '10', '0', '0', '', '', '', '1302598782'), ('2', '1', '10', '2', '1', '15', '15', '0', '', '', '', '1302674666'), ('3', '1', '5', '1', '1', '15', '15', '0', '', '', '', '1302601860'), ('4', '1', '16', '1', '1', '5', '5', '0', '', '', '', '1302625363');
COMMIT;

-- ----------------------------
-- Table structure for `thx_creditrule`
-- ----------------------------
DROP TABLE IF EXISTS `thx_creditrule`;
CREATE TABLE `thx_creditrule` (
`rid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`rulename`  char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`action`  char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`cycletype`  tinyint(1) NOT NULL DEFAULT 0 ,
`cycletime`  int(10) NOT NULL DEFAULT 0 ,
`rewardnum`  tinyint(2) NOT NULL DEFAULT 1 ,
`rewardtype`  tinyint(1) NOT NULL DEFAULT 1 ,
`norepeat`  tinyint(1) NOT NULL DEFAULT 0 ,
`credit`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`experience`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`rid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=48

;

-- ----------------------------
-- Records of thx_creditrule
-- ----------------------------
BEGIN;
INSERT INTO thx_creditrule VALUES ('1', '开通空间', 'register', '0', '0', '1', '1', '0', '10', '0'), ('2', '实名认证', 'realname', '0', '0', '1', '1', '0', '20', '20'), ('3', '邮箱认证', 'realemail', '0', '0', '1', '1', '0', '40', '40'), ('4', '成功邀请好友', 'invitefriend', '4', '0', '20', '1', '0', '10', '10'), ('5', '设置头像', 'setavatar', '0', '0', '1', '1', '0', '15', '15'), ('6', '视频认证', 'videophoto', '0', '0', '1', '1', '0', '40', '40'), ('7', '成功举报', 'report', '4', '0', '0', '1', '0', '2', '2'), ('8', '更新心情', 'updatemood', '1', '0', '3', '1', '0', '3', '3'), ('9', '热点信息', 'hotinfo', '4', '0', '0', '1', '0', '10', '10'), ('10', '每天登陆', 'daylogin', '1', '0', '1', '1', '0', '15', '15'), ('11', '访问别人空间', 'visit', '1', '0', '10', '1', '2', '1', '1'), ('12', '打招呼', 'poke', '1', '0', '10', '1', '2', '1', '1'), ('13', '留言', 'guestbook', '1', '0', '20', '1', '2', '2', '2'), ('14', '被留言', 'getguestbook', '1', '0', '5', '1', '2', '1', '0'), ('15', '发表记录', 'doing', '1', '0', '5', '1', '0', '1', '1'), ('16', '发表日志', 'publishblog', '1', '0', '3', '1', '0', '5', '5'), ('17', '上传图片', 'uploadimage', '1', '0', '10', '1', '0', '2', '2'), ('18', '拍大头贴', 'camera', '1', '0', '5', '1', '0', '3', '3'), ('19', '发表话题', 'publishthread', '1', '0', '5', '1', '0', '5', '5'), ('20', '回复话题', 'replythread', '1', '0', '10', '1', '1', '1', '1'), ('21', '创建投票', 'createpoll', '1', '0', '5', '1', '0', '2', '2'), ('22', '参与投票', 'joinpoll', '1', '0', '10', '1', '1', '1', '1'), ('23', '发起活动', 'createevent', '1', '0', '1', '1', '0', '3', '3'), ('24', '参与活动', 'joinevent', '1', '0', '1', '1', '1', '1', '1'), ('25', '推荐活动', 'recommendevent', '4', '0', '0', '1', '0', '10', '10'), ('26', '发起分享', 'createshare', '1', '0', '3', '1', '0', '2', '2'), ('27', '评论', 'comment', '1', '0', '40', '1', '1', '1', '1'), ('28', '被评论', 'getcomment', '1', '0', '20', '1', '1', '1', '0'), ('29', '安装应用', 'installapp', '4', '0', '0', '1', '3', '5', '5'), ('30', '使用应用', 'useapp', '1', '0', '10', '1', '3', '1', '1'), ('31', '信息表态', 'click', '1', '0', '10', '1', '1', '1', '1'), ('32', '修改实名', 'editrealname', '0', '0', '1', '0', '0', '5', '0'), ('33', '更改邮箱认证', 'editrealemail', '0', '0', '1', '0', '0', '5', '0'), ('34', '头像被删除', 'delavatar', '0', '0', '1', '0', '0', '10', '10'), ('35', '获取邀请码', 'invitecode', '0', '0', '1', '0', '0', '0', '0'), ('36', '搜索一次', 'search', '0', '0', '1', '0', '0', '1', '0'), ('37', '日志导入', 'blogimport', '0', '0', '1', '0', '0', '10', '0'), ('38', '修改域名', 'modifydomain', '0', '0', '1', '0', '0', '5', '0'), ('39', '日志被删除', 'delblog', '0', '0', '1', '0', '0', '10', '10'), ('40', '记录被删除', 'deldoing', '0', '0', '1', '0', '0', '2', '2'), ('41', '图片被删除', 'delimage', '0', '0', '1', '0', '0', '4', '4'), ('42', '投票被删除', 'delpoll', '0', '0', '1', '0', '0', '4', '4'), ('43', '话题被删除', 'delthread', '0', '0', '1', '0', '0', '4', '4'), ('44', '活动被删除', 'delevent', '0', '0', '1', '0', '0', '6', '6'), ('45', '分享被删除', 'delshare', '0', '0', '1', '0', '0', '4', '4'), ('46', '留言被删除', 'delguestbook', '0', '0', '1', '0', '0', '4', '4'), ('47', '评论被删除', 'delcomment', '0', '0', '1', '0', '0', '2', '2');
COMMIT;

-- ----------------------------
-- Table structure for `thx_cron`
-- ----------------------------
DROP TABLE IF EXISTS `thx_cron`;
CREATE TABLE `thx_cron` (
`cronid`  smallint(6) UNSIGNED NOT NULL AUTO_INCREMENT ,
`available`  tinyint(1) NOT NULL DEFAULT 0 ,
`type`  enum('user','system') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'user' ,
`name`  char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`filename`  char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`lastrun`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`nextrun`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`weekday`  tinyint(1) NOT NULL DEFAULT 0 ,
`day`  tinyint(2) NOT NULL DEFAULT 0 ,
`hour`  tinyint(2) NOT NULL DEFAULT 0 ,
`minute`  char(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
PRIMARY KEY (`cronid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=6

;

-- ----------------------------
-- Records of thx_cron
-- ----------------------------
BEGIN;
INSERT INTO thx_cron VALUES ('1', '1', 'system', '更新浏览数统计', 'log.php', '1302703741', '1302703800', '-1', '-1', '-1', '0	5	10	15	20	25	30	35	40	45	50	55'), ('2', '1', 'system', '清理过期feed', 'cleanfeed.php', '1302675210', '1302721440', '-1', '-1', '3', '4'), ('3', '1', 'system', '清理个人通知', 'cleannotification.php', '1302675221', '1302728760', '-1', '-1', '5', '6'), ('4', '1', 'system', '同步UC的feed', 'getfeed.php', '1302703785', '1302703920', '-1', '-1', '-1', '2	7	12	17	22	27	32	37	42	47	52'), ('5', '1', 'system', '清理脚印和最新访客', 'cleantrace.php', '1302674970', '1302717780', '-1', '-1', '2', '3');
COMMIT;

-- ----------------------------
-- Table structure for `thx_data`
-- ----------------------------
DROP TABLE IF EXISTS `thx_data`;
CREATE TABLE `thx_data` (
`var`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`datavalue`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`var`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_data
-- ----------------------------
BEGIN;
INSERT INTO thx_data VALUES ('mail', 'a:9:{s:8:\"mailsend\";s:1:\"1\";s:13:\"maildelimiter\";s:1:\"0\";s:12:\"mailusername\";s:1:\"1\";s:6:\"server\";s:0:\"\";s:4:\"port\";s:0:\"\";s:4:\"auth\";s:1:\"0\";s:4:\"from\";s:0:\"\";s:13:\"auth_username\";s:0:\"\";s:13:\"auth_password\";s:0:\"\";}', '1302674712'), ('setting', 'a:14:{s:10:\"thumbwidth\";s:3:\"100\";s:11:\"thumbheight\";s:3:\"100\";s:13:\"maxthumbwidth\";s:0:\"\";s:14:\"maxthumbheight\";s:0:\"\";s:13:\"watermarkfile\";s:0:\"\";s:12:\"watermarkpos\";s:1:\"4\";s:6:\"ftpssl\";s:1:\"0\";s:7:\"ftphost\";s:0:\"\";s:7:\"ftpport\";s:0:\"\";s:7:\"ftpuser\";s:0:\"\";s:11:\"ftppassword\";s:0:\"\";s:7:\"ftppasv\";s:1:\"0\";s:6:\"ftpdir\";s:0:\"\";s:10:\"ftptimeout\";s:0:\"\";}', '1302674712'), ('network', 'a:5:{s:4:\"blog\";a:2:{s:4:\"hot1\";s:1:\"3\";s:5:\"cache\";s:3:\"600\";}s:3:\"pic\";a:2:{s:4:\"hot1\";s:1:\"3\";s:5:\"cache\";s:3:\"700\";}s:6:\"thread\";a:2:{s:4:\"hot1\";s:1:\"3\";s:5:\"cache\";s:3:\"800\";}s:5:\"event\";a:1:{s:5:\"cache\";s:3:\"900\";}s:4:\"poll\";a:1:{s:5:\"cache\";s:3:\"500\";}}', '1302598775'), ('newspacelist', 'a:1:{i:0;a:6:{s:3:\"uid\";s:1:\"1\";s:8:\"username\";s:5:\"admin\";s:4:\"name\";s:0:\"\";s:10:\"namestatus\";s:1:\"0\";s:11:\"videostatus\";s:1:\"0\";s:8:\"dateline\";s:10:\"1302598782\";}}', '1302598782'), ('reason', '', '0'), ('registerrule', '', '0'), ('spam', 'a:0:{}', '1302601881');
COMMIT;

-- ----------------------------
-- Table structure for `thx_docomment`
-- ----------------------------
DROP TABLE IF EXISTS `thx_docomment`;
CREATE TABLE `thx_docomment` (
`id`  int(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`upid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`doid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`message`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`ip`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`grade`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_docomment
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_doing`
-- ----------------------------
DROP TABLE IF EXISTS `thx_doing`;
CREATE TABLE `thx_doing` (
`doid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`from`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`message`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`ip`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`replynum`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`mood`  smallint(6) NOT NULL DEFAULT 0 ,
PRIMARY KEY (`doid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_doing
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_event`
-- ----------------------------
DROP TABLE IF EXISTS `thx_event`;
CREATE TABLE `thx_event` (
`eventid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`topicid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`title`  varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`classid`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`province`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`city`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`location`  varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`poster`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`thumb`  tinyint(1) NOT NULL DEFAULT 0 ,
`remote`  tinyint(1) NOT NULL DEFAULT 0 ,
`deadline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`starttime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`endtime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`public`  tinyint(3) NOT NULL DEFAULT 0 ,
`membernum`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`follownum`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`viewnum`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`grade`  tinyint(3) NOT NULL DEFAULT 0 ,
`recommendtime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`tagid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`picnum`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`threadnum`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`updatetime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`hot`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`eventid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_event
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_eventclass`
-- ----------------------------
DROP TABLE IF EXISTS `thx_eventclass`;
CREATE TABLE `thx_eventclass` (
`classid`  smallint(6) UNSIGNED NOT NULL AUTO_INCREMENT ,
`classname`  varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`poster`  tinyint(1) NOT NULL DEFAULT 0 ,
`template`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`displayorder`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`classid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=7

;

-- ----------------------------
-- Records of thx_eventclass
-- ----------------------------
BEGIN;
INSERT INTO thx_eventclass VALUES ('1', '生活/聚会', '0', '费用说明：\r\n集合地点：\r\n着装要求：\r\n联系方式：\r\n注意事项：', '1'), ('2', '出行/旅游', '0', '路线说明:\r\n费用说明:\r\n装备要求:\r\n交通工具:\r\n集合地点:\r\n联系方式:\r\n注意事项:', '2'), ('3', '比赛/运动', '0', '费用说明：\r\n集合地点：\r\n着装要求：\r\n场地介绍：\r\n联系方式：\r\n注意事项：', '4'), ('4', '电影/演出', '0', '剧情介绍：\r\n费用说明：\r\n集合地点：\r\n联系方式：\r\n注意事项：', '3'), ('5', '教育/讲座', '0', '主办单位：\r\n活动主题：\r\n费用说明：\r\n集合地点：\r\n联系方式：\r\n注意事项：', '5'), ('6', '其它', '0', '', '6');
COMMIT;

-- ----------------------------
-- Table structure for `thx_eventfield`
-- ----------------------------
DROP TABLE IF EXISTS `thx_eventfield`;
CREATE TABLE `thx_eventfield` (
`eventid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`detail`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`template`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`limitnum`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`verify`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowpic`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowpost`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowinvite`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowfellow`  tinyint(1) NOT NULL DEFAULT 0 ,
`hotuser`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`eventid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_eventfield
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_eventinvite`
-- ----------------------------
DROP TABLE IF EXISTS `thx_eventinvite`;
CREATE TABLE `thx_eventinvite` (
`eventid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`touid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`tousername`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`eventid`, `touid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_eventinvite
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_eventpic`
-- ----------------------------
DROP TABLE IF EXISTS `thx_eventpic`;
CREATE TABLE `thx_eventpic` (
`picid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`eventid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`picid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_eventpic
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_feed`
-- ----------------------------
DROP TABLE IF EXISTS `thx_feed`;
CREATE TABLE `thx_feed` (
`feedid`  int(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`appid`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`icon`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`friend`  tinyint(1) NOT NULL DEFAULT 0 ,
`hash_template`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`hash_data`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`title_template`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`title_data`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`body_template`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`body_data`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`body_general`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`image_1`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`image_1_link`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`image_2`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`image_2_link`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`image_3`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`image_3_link`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`image_4`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`image_4_link`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`target_ids`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`id`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`idtype`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`hot`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`feedid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=4

;

-- ----------------------------
-- Records of thx_feed
-- ----------------------------
BEGIN;
INSERT INTO thx_feed VALUES ('1', '1', 'profile', '1', 'admin', '1302598782', '0', '3a7101a64ea7927f0b3f5179b7a457b3', 'ec7d775d9211880bca2ba1d401e3bcb9', '{actor} 开通了自己的个人主页', 'a:0:{}', '', 'a:0:{}', '', '', '', '', '', '', '', '', '', '', '0', '', '0'), ('2', '1', 'blog', '1', 'admin', '1302497281', '0', '2c24ba00fafd81b79f331389e04a26cb', '2ae5869f31bb0e1d63e30b1e85c91269', '{actor} 发表了新日志', 'N;', '<b>{subject}</b><br>{summary}', 'a:2:{s:7:\"subject\";s:62:\"<a href=\"space.php?uid=1&do=blog&id=12\">知识分类你好</a>\";s:7:\"summary\";s:216:\"知识分类知识分类知识分类知识分类知识分类知识分类知识分类         知识分类知识分类知识分类知识分类知识分类知识分类知识分类         知识分类知识分类知识\";}', '', 'attachment/201104/12/1_13026147412i4i.jpg', 'space.php?uid=1&do=blog&id=12', '', '', '', '', '', '', '', '12', 'blogid', '0'), ('3', '1', 'blog', '1', 'admin', '1302625363', '0', '2c24ba00fafd81b79f331389e04a26cb', 'abad38a2ed0f3616ea055cd272f46caf', '{actor} 发表了新日志', 'N;', '<b>{subject}</b><br>{summary}', 'a:2:{s:7:\"subject\";s:53:\"<a href=\"space.php?uid=1&do=blog&id=16\">哈哈哈</a>\";s:7:\"summary\";s:9:\"哈哈哈\";}', '', 'attachment/201104/12/1_13026147412i4i.jpg', 'space.php?uid=1&do=blog&id=16', '', '', '', '', '', '', '', '16', 'blogid', '0');
COMMIT;

-- ----------------------------
-- Table structure for `thx_friend`
-- ----------------------------
DROP TABLE IF EXISTS `thx_friend`;
CREATE TABLE `thx_friend` (
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`fuid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`fusername`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`status`  tinyint(1) NOT NULL DEFAULT 0 ,
`gid`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`note`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`num`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`uid`, `fuid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_friend
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_friendguide`
-- ----------------------------
DROP TABLE IF EXISTS `thx_friendguide`;
CREATE TABLE `thx_friendguide` (
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`fuid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`fusername`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`num`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`uid`, `fuid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_friendguide
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_friendlog`
-- ----------------------------
DROP TABLE IF EXISTS `thx_friendlog`;
CREATE TABLE `thx_friendlog` (
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`fuid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`action`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`uid`, `fuid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_friendlog
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_invite`
-- ----------------------------
DROP TABLE IF EXISTS `thx_invite`;
CREATE TABLE `thx_invite` (
`id`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`code`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`fuid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`fusername`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`type`  tinyint(1) NOT NULL DEFAULT 0 ,
`email`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`appid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_invite
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_log`
-- ----------------------------
DROP TABLE IF EXISTS `thx_log`;
CREATE TABLE `thx_log` (
`logid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`id`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`idtype`  char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
PRIMARY KEY (`logid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_magic`
-- ----------------------------
DROP TABLE IF EXISTS `thx_magic`;
CREATE TABLE `thx_magic` (
`mid`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`name`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`description`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`forbiddengid`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`charge`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`experience`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`provideperoid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`providecount`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`useperoid`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`usecount`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`displayorder`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`custom`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`close`  tinyint(1) NOT NULL DEFAULT 0 ,
PRIMARY KEY (`mid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_magic
-- ----------------------------
BEGIN;
INSERT INTO thx_magic VALUES ('invisible', '隐身草', '让自己隐身登录，不显示在线，24小时内有效', '', '50', '5', '86400', '10', '86400', '1', '0', '', '0'), ('friendnum', '好友增容卡', '在允许添加的最多好友数限制外，增加10个好友名额', '', '30', '3', '86400', '999', '0', '1', '0', '', '0'), ('attachsize', '附件增容卡', '使用一次，可以给自己增加 10M 的附件空间', '', '30', '3', '86400', '999', '0', '1', '0', '', '0'), ('thunder', '雷鸣之声', '发布一条全站信息，让大家知道自己上线了', '', '500', '5', '86400', '5', '86400', '1', '0', '', '0'), ('updateline', '救生圈', '把指定对象的发布时间更新为当前时间', '', '200', '5', '86400', '999', '0', '1', '0', '', '0'), ('downdateline', '时空机', '把指定对象的发布时间修改为过去的时间', '', '250', '5', '86400', '999', '0', '1', '0', '', '0'), ('color', '彩色灯', '把指定对象的标题变成彩色的', '', '50', '5', '86400', '999', '0', '1', '0', '', '0'), ('hot', '热点灯', '把指定对象的热度增加站点推荐的热点值', '', '50', '5', '86400', '999', '0', '1', '0', '', '0'), ('visit', '互访卡', '随机选择10个好友，向其打招呼、留言或访问空间', '', '20', '2', '86400', '999', '0', '1', '0', '', '0'), ('icon', '彩虹蛋', '给指定对象的标题前面增加图标（最多8个图标）', '', '20', '2', '86400', '999', '0', '1', '0', '', '0'), ('flicker', '彩虹炫', '让评论、留言的文字闪烁起来', '', '30', '3', '86400', '999', '0', '1', '0', '', '0'), ('gift', '红包卡', '在自己的空间埋下积分红包送给来访者', '', '20', '2', '86400', '999', '0', '1', '0', '', '0'), ('superstar', '超级明星', '在个人主页，给自己的头像增加超级明星标识', '', '30', '3', '86400', '999', '0', '1', '0', '', '0'), ('viewmagiclog', '八卦镜', '查看指定用户最近使用的道具记录', '', '100', '5', '86400', '999', '0', '1', '0', '', '0'), ('viewmagic', '透视镜', '查看指定用户当前持有的道具', '', '100', '5', '86400', '999', '0', '1', '0', '', '0'), ('viewvisitor', '偷窥镜', '查看指定用户最近访问过的10个空间', '', '100', '5', '86400', '999', '0', '1', '0', '', '0'), ('call', '点名卡', '发通知给自己的好友，让他们来查看指定的对象', '', '50', '5', '86400', '999', '0', '1', '0', '', '0'), ('coupon', '代金券', '购买道具时折换一定量的积分', '', '0', '0', '0', '0', '0', '1', '0', '', '0'), ('frame', '相框', '给自己的照片添上相框', '', '30', '3', '86400', '999', '0', '1', '0', '', '0'), ('bgimage', '信纸', '给指定的对象添加信纸背景', '', '30', '3', '86400', '999', '0', '1', '0', '', '0'), ('doodle', '涂鸦板', '允许在留言、评论等操作时使用涂鸦板', '', '30', '3', '86400', '999', '0', '1', '0', '', '0'), ('anonymous', '匿名卡', '在指定的地方，让自己的名字显示为匿名', '', '50', '5', '86400', '999', '0', '1', '0', '', '0'), ('reveal', '照妖镜', '可以查看一次匿名用户的真实身份', '', '100', '5', '86400', '999', '0', '1', '0', '', '0'), ('license', '道具转让许可证', '使用许可证，将道具赠送给指定好友', '', '10', '1', '3600', '999', '0', '1', '0', '', '0'), ('detector', '探测器', '探测埋了红包的空间', '', '10', '1', '86400', '999', '0', '1', '0', '', '0');
COMMIT;

-- ----------------------------
-- Table structure for `thx_magicinlog`
-- ----------------------------
DROP TABLE IF EXISTS `thx_magicinlog`;
CREATE TABLE `thx_magicinlog` (
`logid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`mid`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`count`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`type`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`fromid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`credit`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`dateline`  int(10) NOT NULL DEFAULT 0 ,
PRIMARY KEY (`logid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_magicinlog
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_magicstore`
-- ----------------------------
DROP TABLE IF EXISTS `thx_magicstore`;
CREATE TABLE `thx_magicstore` (
`mid`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`storage`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`lastprovide`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`sellcount`  int(8) UNSIGNED NOT NULL DEFAULT 0 ,
`sellcredit`  int(8) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`mid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_magicstore
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_magicuselog`
-- ----------------------------
DROP TABLE IF EXISTS `thx_magicuselog`;
CREATE TABLE `thx_magicuselog` (
`logid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`mid`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`id`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`idtype`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`count`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`data`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`expire`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`logid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_magicuselog
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_mailcron`
-- ----------------------------
DROP TABLE IF EXISTS `thx_mailcron`;
CREATE TABLE `thx_mailcron` (
`cid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`touid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`email`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`sendtime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`cid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_mailcron
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_mailqueue`
-- ----------------------------
DROP TABLE IF EXISTS `thx_mailqueue`;
CREATE TABLE `thx_mailqueue` (
`qid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`cid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`subject`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`message`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`qid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_mailqueue
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_member`
-- ----------------------------
DROP TABLE IF EXISTS `thx_member`;
CREATE TABLE `thx_member` (
`uid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`username`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`password`  char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
PRIMARY KEY (`uid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=2

;

-- ----------------------------
-- Records of thx_member
-- ----------------------------
BEGIN;
INSERT INTO thx_member VALUES ('1', 'admin', '43f592b3c1de63fb1b90e34a1697b72c');
COMMIT;

-- ----------------------------
-- Table structure for `thx_mtag`
-- ----------------------------
DROP TABLE IF EXISTS `thx_mtag`;
CREATE TABLE `thx_mtag` (
`tagid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`tagname`  varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`fieldid`  smallint(6) NOT NULL DEFAULT 0 ,
`membernum`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`threadnum`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`postnum`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`close`  tinyint(1) NOT NULL DEFAULT 0 ,
`announcement`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`pic`  varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`closeapply`  tinyint(1) NOT NULL DEFAULT 0 ,
`joinperm`  tinyint(1) NOT NULL DEFAULT 0 ,
`viewperm`  tinyint(1) NOT NULL DEFAULT 0 ,
`threadperm`  tinyint(1) NOT NULL DEFAULT 0 ,
`postperm`  tinyint(1) NOT NULL DEFAULT 0 ,
`recommend`  tinyint(1) NOT NULL DEFAULT 0 ,
`moderator`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
PRIMARY KEY (`tagid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_mtag
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_mtaginvite`
-- ----------------------------
DROP TABLE IF EXISTS `thx_mtaginvite`;
CREATE TABLE `thx_mtaginvite` (
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`tagid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`fromuid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`fromusername`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`uid`, `tagid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_mtaginvite
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_myapp`
-- ----------------------------
DROP TABLE IF EXISTS `thx_myapp`;
CREATE TABLE `thx_myapp` (
`appid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`appname`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`narrow`  tinyint(1) NOT NULL DEFAULT 0 ,
`flag`  tinyint(1) NOT NULL DEFAULT 0 ,
`version`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`displaymethod`  tinyint(1) NOT NULL DEFAULT 0 ,
`displayorder`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`appid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_myapp
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_myinvite`
-- ----------------------------
DROP TABLE IF EXISTS `thx_myinvite`;
CREATE TABLE `thx_myinvite` (
`id`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`typename`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`appid`  mediumint(8) NOT NULL DEFAULT 0 ,
`type`  tinyint(1) NOT NULL DEFAULT 0 ,
`fromuid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`touid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`myml`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`hash`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_myinvite
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_notification`
-- ----------------------------
DROP TABLE IF EXISTS `thx_notification`;
CREATE TABLE `thx_notification` (
`id`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`type`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`new`  tinyint(1) NOT NULL DEFAULT 0 ,
`authorid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`author`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`note`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_notification
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_pic`
-- ----------------------------
DROP TABLE IF EXISTS `thx_pic`;
CREATE TABLE `thx_pic` (
`picid`  mediumint(8) NOT NULL AUTO_INCREMENT ,
`albumid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`topicid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`postip`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`filename`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`title`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`type`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`size`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`filepath`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`thumb`  tinyint(1) NOT NULL DEFAULT 0 ,
`remote`  tinyint(1) NOT NULL DEFAULT 0 ,
`hot`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`click_6`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`click_7`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`click_8`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`click_9`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`click_10`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`magicframe`  tinyint(6) NOT NULL DEFAULT 0 ,
PRIMARY KEY (`picid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=2

;

-- ----------------------------
-- Records of thx_pic
-- ----------------------------
BEGIN;
INSERT INTO thx_pic VALUES ('1', '0', '0', '1', 'admin', '1302614741', '183.13.179.151', 'asusbbs.zol.com.cn_暮霭古藤_4746198_s.jpg', '', 'image/jpeg', '13040', '201104/12/1_13026147412i4i.jpg', '0', '0', '0', '0', '0', '0', '0', '0', '0');
COMMIT;

-- ----------------------------
-- Table structure for `thx_picfield`
-- ----------------------------
DROP TABLE IF EXISTS `thx_picfield`;
CREATE TABLE `thx_picfield` (
`picid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`hotuser`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`picid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_picfield
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_poke`
-- ----------------------------
DROP TABLE IF EXISTS `thx_poke`;
CREATE TABLE `thx_poke` (
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`fromuid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`fromusername`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`note`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`iconid`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`uid`, `fromuid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_poke
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_poll`
-- ----------------------------
DROP TABLE IF EXISTS `thx_poll`;
CREATE TABLE `thx_poll` (
`pid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`topicid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`subject`  char(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`voternum`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`replynum`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`multiple`  tinyint(1) NOT NULL DEFAULT 0 ,
`maxchoice`  tinyint(3) NOT NULL DEFAULT 0 ,
`sex`  tinyint(1) NOT NULL DEFAULT 0 ,
`noreply`  tinyint(1) NOT NULL DEFAULT 0 ,
`credit`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`percredit`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`expiration`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`lastvote`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`hot`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`pid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_poll
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_pollfield`
-- ----------------------------
DROP TABLE IF EXISTS `thx_pollfield`;
CREATE TABLE `thx_pollfield` (
`pid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`notify`  tinyint(1) NOT NULL DEFAULT 0 ,
`message`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`summary`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`option`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`invite`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`hotuser`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`pid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_pollfield
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_polloption`
-- ----------------------------
DROP TABLE IF EXISTS `thx_polloption`;
CREATE TABLE `thx_polloption` (
`oid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`pid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`votenum`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`option`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
PRIMARY KEY (`oid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_polloption
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_polluser`
-- ----------------------------
DROP TABLE IF EXISTS `thx_polluser`;
CREATE TABLE `thx_polluser` (
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`pid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`option`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`uid`, `pid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_polluser
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_post`
-- ----------------------------
DROP TABLE IF EXISTS `thx_post`;
CREATE TABLE `thx_post` (
`pid`  int(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`tagid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`tid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`ip`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`message`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`pic`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`isthread`  tinyint(1) NOT NULL DEFAULT 0 ,
`hotuser`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`pid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_post
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_product`
-- ----------------------------
DROP TABLE IF EXISTS `thx_product`;
CREATE TABLE `thx_product` (
`picid`  mediumint(8) NOT NULL AUTO_INCREMENT ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`postip`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`filename`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`title`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`filepath`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`cat`  int(60) NOT NULL DEFAULT 0 ,
`subcat`  int(60) NOT NULL DEFAULT 0 ,
`name`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`picid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=34

;

-- ----------------------------
-- Records of thx_product
-- ----------------------------
BEGIN;
INSERT INTO thx_product VALUES ('21', '1', 'admin', '1302593595', '127.0.0.1', '9b5c7ab7a05e9fa9689369b26f36f652.jpg', '珠宝', 'swfupload/product/9b5c7ab7a05e9fa9689369b26f36f652.jpg', '1', '22', '永恒婚介'), ('23', '1', 'admin', '1302591618', '127.0.0.1', '4d76449244552889c085277b0a177f43.jpg', '单打独斗', 'swfupload/product/4d76449244552889c085277b0a177f43.jpg', '1', '11', '单打独斗'), ('24', '1', 'admin', '1302591638', '127.0.0.1', 'eccd13ed7a2ba623ef9a44bb519ad6f3.jpg', '对方答复', 'swfupload/product/eccd13ed7a2ba623ef9a44bb519ad6f3.jpg', '1', '11', '对方答复的'), ('25', '1', 'admin', '1302591629', '127.0.0.1', '709da3ce6c22b598224bebe30c17b738.jpg', '对方答复的', 'swfupload/product/709da3ce6c22b598224bebe30c17b738.jpg', '1', '22', '答复对方答复的'), ('26', '1', 'admin', '1302591647', '127.0.0.1', '482cedf044fd9c1c0400d2da64da93b4.jpg', '带的饭', 'swfupload/product/482cedf044fd9c1c0400d2da64da93b4.jpg', '1', '22', '大幅的服务为'), ('27', '1', 'admin', '1302591659', '127.0.0.1', '37aca520d28975077e6806a0a2a9dca8.jpg', '对对方答复', 'swfupload/product/37aca520d28975077e6806a0a2a9dca8.jpg', '1', '22', '对方答复哈哈哈'), ('28', '1', 'admin', '1302591669', '127.0.0.1', 'b1fcbaa8a7d33d8528b59dfda5dc5803.jpg', '对方答复', 'swfupload/product/b1fcbaa8a7d33d8528b59dfda5dc5803.jpg', '1', '11', '后很快'), ('29', '1', 'admin', '1302591680', '127.0.0.1', '5ce10111401ee330fa24a57bf6d0ac92.jpg', '对方答复的', 'swfupload/product/5ce10111401ee330fa24a57bf6d0ac92.jpg', '1', '22', '干回锅肉'), ('30', '1', 'admin', '1302591689', '127.0.0.1', '63af0faf468f1ec3dc7258eb69020cae.jpg', '对方答复', 'swfupload/product/63af0faf468f1ec3dc7258eb69020cae.jpg', '1', '11', '大幅度后举行'), ('32', '1', 'admin', '1302623401', '183.13.179.151', '6e09dc29762f2ddaad201c16ec22190a.jpg', '美女', 'swfupload/product/6e09dc29762f2ddaad201c16ec22190a.jpg', '1', '22', '美女'), ('33', '1', 'admin', '1302677319', '113.108.110.50', '8f386f03afdc3f9583e963dd4a3b4b4b.jpg', '这是说明文字！！！！！！', 'swfupload/product/8f386f03afdc3f9583e963dd4a3b4b4b.jpg', '1', '0', '万科珠宝');
COMMIT;

-- ----------------------------
-- Table structure for `thx_profield`
-- ----------------------------
DROP TABLE IF EXISTS `thx_profield`;
CREATE TABLE `thx_profield` (
`fieldid`  smallint(6) UNSIGNED NOT NULL AUTO_INCREMENT ,
`title`  varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`note`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`formtype`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' ,
`inputnum`  smallint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`choice`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`mtagminnum`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`manualmoderator`  tinyint(1) NOT NULL DEFAULT 0 ,
`manualmember`  tinyint(1) NOT NULL DEFAULT 0 ,
`displayorder`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`fieldid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=4

;

-- ----------------------------
-- Records of thx_profield
-- ----------------------------
BEGIN;
INSERT INTO thx_profield VALUES ('1', '自由联盟', '', 'text', '100', '', '0', '0', '1', '0'), ('2', '地区联盟', '', 'text', '100', '', '0', '0', '1', '0'), ('3', '兴趣联盟', '', 'text', '100', '', '0', '0', '1', '0');
COMMIT;

-- ----------------------------
-- Table structure for `thx_profilefield`
-- ----------------------------
DROP TABLE IF EXISTS `thx_profilefield`;
CREATE TABLE `thx_profilefield` (
`fieldid`  smallint(6) UNSIGNED NOT NULL AUTO_INCREMENT ,
`title`  varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`note`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`formtype`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' ,
`maxsize`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`required`  tinyint(1) NOT NULL DEFAULT 0 ,
`invisible`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowsearch`  tinyint(1) NOT NULL DEFAULT 0 ,
`choice`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`displayorder`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`fieldid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_profilefield
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_report`
-- ----------------------------
DROP TABLE IF EXISTS `thx_report`;
CREATE TABLE `thx_report` (
`rid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`id`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`idtype`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`new`  tinyint(1) NOT NULL DEFAULT 0 ,
`num`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`reason`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`uids`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`rid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_report
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_session`
-- ----------------------------
DROP TABLE IF EXISTS `thx_session`;
CREATE TABLE `thx_session` (
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`password`  char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`lastactivity`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`ip`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`magichidden`  tinyint(1) NOT NULL DEFAULT 0 ,
PRIMARY KEY (`uid`)
)
ENGINE=MEMORY
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_session
-- ----------------------------
BEGIN;
INSERT INTO thx_session VALUES ('1', 'admin', '43f592b3c1de63fb1b90e34a1697b72c', '1302703785', '113108110', '0');
COMMIT;

-- ----------------------------
-- Table structure for `thx_share`
-- ----------------------------
DROP TABLE IF EXISTS `thx_share`;
CREATE TABLE `thx_share` (
`sid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`topicid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`type`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`title_template`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`body_template`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`body_data`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`body_general`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`image`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`image_link`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`hot`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`hotuser`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`sid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_share
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_show`
-- ----------------------------
DROP TABLE IF EXISTS `thx_show`;
CREATE TABLE `thx_show` (
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`credit`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`note`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
PRIMARY KEY (`uid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_show
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_space`
-- ----------------------------
DROP TABLE IF EXISTS `thx_space`;
CREATE TABLE `thx_space` (
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`groupid`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`credit`  int(10) NOT NULL DEFAULT 0 ,
`experience`  int(10) NOT NULL DEFAULT 0 ,
`username`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`name`  char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`namestatus`  tinyint(1) NOT NULL DEFAULT 0 ,
`videostatus`  tinyint(1) NOT NULL DEFAULT 0 ,
`domain`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`friendnum`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`viewnum`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`notenum`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`addfriendnum`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`mtaginvitenum`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`eventinvitenum`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`myinvitenum`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`pokenum`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`doingnum`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`blognum`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`albumnum`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`threadnum`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`pollnum`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`eventnum`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`sharenum`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`updatetime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`lastsearch`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`lastpost`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`lastlogin`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`lastsend`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`attachsize`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`addsize`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`addfriend`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`flag`  tinyint(1) NOT NULL DEFAULT 0 ,
`newpm`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`avatar`  tinyint(1) NOT NULL DEFAULT 0 ,
`regip`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`ip`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`mood`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`uid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_space
-- ----------------------------
BEGIN;
INSERT INTO thx_space VALUES ('1', '1', '60', '50', 'admin', '', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '16', '0', '0', '0', '0', '0', '1302598782', '1302625363', '0', '1302625363', '1302677066', '0', '13040', '0', '0', '1', '0', '1', '113.108.110.50', '113108110', '0');
COMMIT;

-- ----------------------------
-- Table structure for `thx_spacefield`
-- ----------------------------
DROP TABLE IF EXISTS `thx_spacefield`;
CREATE TABLE `thx_spacefield` (
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`sex`  tinyint(1) NOT NULL DEFAULT 0 ,
`email`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`newemail`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`emailcheck`  tinyint(1) NOT NULL DEFAULT 0 ,
`mobile`  varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`qq`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`msn`  varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`msnrobot`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`msncstatus`  tinyint(1) NOT NULL DEFAULT 0 ,
`videopic`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`birthyear`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`birthmonth`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`birthday`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`blood`  varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`marry`  tinyint(1) NOT NULL DEFAULT 0 ,
`birthprovince`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`birthcity`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`resideprovince`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`residecity`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`note`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`spacenote`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`authstr`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`theme`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`nocss`  tinyint(1) NOT NULL DEFAULT 0 ,
`menunum`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`css`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`privacy`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`friend`  mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`feedfriend`  mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`sendmail`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`magicstar`  tinyint(1) NOT NULL DEFAULT 0 ,
`magicexpire`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`timeoffset`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
PRIMARY KEY (`uid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_spacefield
-- ----------------------------
BEGIN;
INSERT INTO thx_spacefield VALUES ('1', '0', '', '', '0', '', '', '', '', '0', '', '0', '0', '0', '', '0', '', '', '', '', '', '', '', '', '0', '0', '', '', '', '', '', '0', '0', '');
COMMIT;

-- ----------------------------
-- Table structure for `thx_spaceinfo`
-- ----------------------------
DROP TABLE IF EXISTS `thx_spaceinfo`;
CREATE TABLE `thx_spaceinfo` (
`infoid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`type`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`subtype`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`title`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`subtitle`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`friend`  tinyint(1) NOT NULL DEFAULT 0 ,
`startyear`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`endyear`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`startmonth`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`endmonth`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`infoid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_spaceinfo
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_spacelog`
-- ----------------------------
DROP TABLE IF EXISTS `thx_spacelog`;
CREATE TABLE `thx_spacelog` (
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`opuid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`opusername`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`flag`  tinyint(1) NOT NULL DEFAULT 0 ,
`expiration`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`uid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_spacelog
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_stat`
-- ----------------------------
DROP TABLE IF EXISTS `thx_stat`;
CREATE TABLE `thx_stat` (
`daytime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`login`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`register`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`invite`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`appinvite`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`doing`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`blog`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`pic`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`poll`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`event`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`share`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`thread`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`docomment`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`blogcomment`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`piccomment`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`pollcomment`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`pollvote`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`eventcomment`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`eventjoin`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`sharecomment`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`post`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`wall`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`poke`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`click`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`daytime`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_stat
-- ----------------------------
BEGIN;
INSERT INTO thx_stat VALUES ('20110412', '1', '1', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'), ('20110413', '1', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
COMMIT;

-- ----------------------------
-- Table structure for `thx_statuser`
-- ----------------------------
DROP TABLE IF EXISTS `thx_statuser`;
CREATE TABLE `thx_statuser` (
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`daytime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`type`  char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_statuser
-- ----------------------------
BEGIN;
INSERT INTO thx_statuser VALUES ('1', '0', 'login');
COMMIT;

-- ----------------------------
-- Table structure for `thx_tag`
-- ----------------------------
DROP TABLE IF EXISTS `thx_tag`;
CREATE TABLE `thx_tag` (
`tagid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`tagname`  char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`blognum`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`close`  tinyint(1) NOT NULL DEFAULT 0 ,
PRIMARY KEY (`tagid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_tag
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_tagblog`
-- ----------------------------
DROP TABLE IF EXISTS `thx_tagblog`;
CREATE TABLE `thx_tagblog` (
`tagid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`blogid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`tagid`, `blogid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_tagblog
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_tagspace`
-- ----------------------------
DROP TABLE IF EXISTS `thx_tagspace`;
CREATE TABLE `thx_tagspace` (
`tagid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`grade`  smallint(6) NOT NULL DEFAULT 0 ,
PRIMARY KEY (`tagid`, `uid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_tagspace
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_task`
-- ----------------------------
DROP TABLE IF EXISTS `thx_task`;
CREATE TABLE `thx_task` (
`taskid`  smallint(6) UNSIGNED NOT NULL AUTO_INCREMENT ,
`available`  tinyint(1) NOT NULL DEFAULT 0 ,
`name`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`note`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`num`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`maxnum`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`image`  varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`filename`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`starttime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`endtime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`nexttime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`nexttype`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`credit`  smallint(6) NOT NULL DEFAULT 0 ,
`displayorder`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`taskid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=8

;

-- ----------------------------
-- Records of thx_task
-- ----------------------------
BEGIN;
INSERT INTO thx_task VALUES ('1', '1', '更新一下自己的头像', '头像就是你在这里的个人形象。<br>设置自己的头像后，会让更多的朋友记住您。', '0', '0', 'image/task/avatar.gif', 'avatar.php', '0', '0', '0', '', '20', '1'), ('2', '1', '将个人资料补充完整', '把自己的个人资料填写完整吧。<br>这样您会被更多的朋友找到的，系统也会帮您找到朋友。', '0', '0', 'image/task/profile.gif', 'profile.php', '0', '0', '0', '2', '20', '0'), ('3', '1', '发表自己的第一篇日志', '现在，就写下自己的第一篇日志吧。<br>与大家一起分享自己的生活感悟。', '0', '0', 'image/task/blog.gif', 'blog.php', '0', '0', '0', '', '5', '3'), ('4', '1', '寻找并添加五位好友', '有了好友，您发的日志、图片等会被好友及时看到并传播出去；<br>您也会在首页方便及时的看到好友的最新动态。', '0', '0', 'image/task/friend.gif', 'friend.php', '0', '0', '0', '', '50', '4'), ('5', '1', '验证激活自己的邮箱', '填写自己真实的邮箱地址并验证通过。<br>您可以在忘记密码的时候使用该邮箱取回自己的密码；<br>还可以及时接受站内的好友通知等等。', '0', '0', 'image/task/email.gif', 'email.php', '0', '0', '0', '', '10', '5'), ('6', '1', '邀请10个新朋友加入', '邀请一下自己的QQ好友或者邮箱联系人，让亲朋好友一起来加入我们吧。', '0', '0', 'image/task/friend.gif', 'invite.php', '0', '0', '0', '', '100', '6'), ('7', '1', '领取每日访问大礼包', '每天登录访问自己的主页，就可领取大礼包。', '0', '0', 'image/task/gift.gif', 'gift.php', '0', '0', '0', 'day', '5', '99');
COMMIT;

-- ----------------------------
-- Table structure for `thx_thread`
-- ----------------------------
DROP TABLE IF EXISTS `thx_thread`;
CREATE TABLE `thx_thread` (
`tid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`topicid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`tagid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`eventid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`subject`  char(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`magiccolor`  tinyint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`magicegg`  tinyint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`viewnum`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`replynum`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`lastpost`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`lastauthor`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`lastauthorid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`displayorder`  tinyint(1) UNSIGNED NOT NULL DEFAULT 0 ,
`digest`  tinyint(1) NOT NULL DEFAULT 0 ,
`hot`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`click_11`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`click_12`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`click_13`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`click_14`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`click_15`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`tid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_thread
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_topic`
-- ----------------------------
DROP TABLE IF EXISTS `thx_topic`;
CREATE TABLE `thx_topic` (
`topicid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`subject`  varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`message`  mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`jointype`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`joingid`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`pic`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`thumb`  tinyint(1) NOT NULL DEFAULT 0 ,
`remote`  tinyint(1) NOT NULL DEFAULT 0 ,
`joinnum`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`lastpost`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`endtime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`topicid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_topic
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_topicuser`
-- ----------------------------
DROP TABLE IF EXISTS `thx_topicuser`;
CREATE TABLE `thx_topicuser` (
`id`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`topicid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thx_topicuser
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_userapp`
-- ----------------------------
DROP TABLE IF EXISTS `thx_userapp`;
CREATE TABLE `thx_userapp` (
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`appid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`appname`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`privacy`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowsidenav`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowfeed`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowprofilelink`  tinyint(1) NOT NULL DEFAULT 0 ,
`narrow`  tinyint(1) NOT NULL DEFAULT 0 ,
`menuorder`  smallint(6) NOT NULL DEFAULT 0 ,
`displayorder`  smallint(6) NOT NULL DEFAULT 0 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_userapp
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_userappfield`
-- ----------------------------
DROP TABLE IF EXISTS `thx_userappfield`;
CREATE TABLE `thx_userappfield` (
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`appid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`profilelink`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`myml`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_userappfield
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_userevent`
-- ----------------------------
DROP TABLE IF EXISTS `thx_userevent`;
CREATE TABLE `thx_userevent` (
`eventid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`status`  tinyint(4) NOT NULL DEFAULT 0 ,
`fellow`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`template`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
PRIMARY KEY (`eventid`, `uid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_userevent
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_usergroup`
-- ----------------------------
DROP TABLE IF EXISTS `thx_usergroup`;
CREATE TABLE `thx_usergroup` (
`gid`  smallint(6) UNSIGNED NOT NULL AUTO_INCREMENT ,
`grouptitle`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`system`  tinyint(1) NOT NULL DEFAULT 0 ,
`banvisit`  tinyint(1) NOT NULL DEFAULT 0 ,
`explower`  int(10) NOT NULL DEFAULT 0 ,
`maxfriendnum`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`maxattachsize`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`allowhtml`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowcomment`  tinyint(1) NOT NULL DEFAULT 0 ,
`searchinterval`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`searchignore`  tinyint(1) NOT NULL DEFAULT 0 ,
`postinterval`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`spamignore`  tinyint(1) NOT NULL DEFAULT 0 ,
`videophotoignore`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowblog`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowdoing`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowupload`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowshare`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowmtag`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowthread`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowpost`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowcss`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowpoke`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowfriend`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowpoll`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowclick`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowevent`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowmagic`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowpm`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowviewvideopic`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowmyop`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowtopic`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowstat`  tinyint(1) NOT NULL DEFAULT 0 ,
`magicdiscount`  tinyint(1) NOT NULL DEFAULT 0 ,
`verifyevent`  tinyint(1) NOT NULL DEFAULT 0 ,
`edittrail`  tinyint(1) NOT NULL DEFAULT 0 ,
`domainlength`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`closeignore`  tinyint(1) NOT NULL DEFAULT 0 ,
`seccode`  tinyint(1) NOT NULL DEFAULT 0 ,
`color`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`icon`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`manageconfig`  tinyint(1) NOT NULL DEFAULT 0 ,
`managenetwork`  tinyint(1) NOT NULL DEFAULT 0 ,
`manageprofilefield`  tinyint(1) NOT NULL DEFAULT 0 ,
`manageprofield`  tinyint(1) NOT NULL DEFAULT 0 ,
`manageusergroup`  tinyint(1) NOT NULL DEFAULT 0 ,
`managefeed`  tinyint(1) NOT NULL DEFAULT 0 ,
`manageshare`  tinyint(1) NOT NULL DEFAULT 0 ,
`managedoing`  tinyint(1) NOT NULL DEFAULT 0 ,
`manageblog`  tinyint(1) NOT NULL DEFAULT 0 ,
`managetag`  tinyint(1) NOT NULL DEFAULT 0 ,
`managetagtpl`  tinyint(1) NOT NULL DEFAULT 0 ,
`managealbum`  tinyint(1) NOT NULL DEFAULT 0 ,
`managecomment`  tinyint(1) NOT NULL DEFAULT 0 ,
`managemtag`  tinyint(1) NOT NULL DEFAULT 0 ,
`managethread`  tinyint(1) NOT NULL DEFAULT 0 ,
`manageevent`  tinyint(1) NOT NULL DEFAULT 0 ,
`manageeventclass`  tinyint(1) NOT NULL DEFAULT 0 ,
`managecensor`  tinyint(1) NOT NULL DEFAULT 0 ,
`managead`  tinyint(1) NOT NULL DEFAULT 0 ,
`managesitefeed`  tinyint(1) NOT NULL DEFAULT 0 ,
`managebackup`  tinyint(1) NOT NULL DEFAULT 0 ,
`manageblock`  tinyint(1) NOT NULL DEFAULT 0 ,
`managetemplate`  tinyint(1) NOT NULL DEFAULT 0 ,
`managestat`  tinyint(1) NOT NULL DEFAULT 0 ,
`managecache`  tinyint(1) NOT NULL DEFAULT 0 ,
`managecredit`  tinyint(1) NOT NULL DEFAULT 0 ,
`managecron`  tinyint(1) NOT NULL DEFAULT 0 ,
`managename`  tinyint(1) NOT NULL DEFAULT 0 ,
`manageapp`  tinyint(1) NOT NULL DEFAULT 0 ,
`managetask`  tinyint(1) NOT NULL DEFAULT 0 ,
`managereport`  tinyint(1) NOT NULL DEFAULT 0 ,
`managepoll`  tinyint(1) NOT NULL DEFAULT 0 ,
`manageclick`  tinyint(1) NOT NULL DEFAULT 0 ,
`managemagic`  tinyint(1) NOT NULL DEFAULT 0 ,
`managemagiclog`  tinyint(1) NOT NULL DEFAULT 0 ,
`managebatch`  tinyint(1) NOT NULL DEFAULT 0 ,
`managedelspace`  tinyint(1) NOT NULL DEFAULT 0 ,
`managetopic`  tinyint(1) NOT NULL DEFAULT 0 ,
`manageip`  tinyint(1) NOT NULL DEFAULT 0 ,
`managehotuser`  tinyint(1) NOT NULL DEFAULT 0 ,
`managedefaultuser`  tinyint(1) NOT NULL DEFAULT 0 ,
`managespacegroup`  tinyint(1) NOT NULL DEFAULT 0 ,
`managespaceinfo`  tinyint(1) NOT NULL DEFAULT 0 ,
`managespacecredit`  tinyint(1) NOT NULL DEFAULT 0 ,
`managespacenote`  tinyint(1) NOT NULL DEFAULT 0 ,
`managevideophoto`  tinyint(1) NOT NULL DEFAULT 0 ,
`managelog`  tinyint(1) NOT NULL DEFAULT 0 ,
`magicaward`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`gid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=10

;

-- ----------------------------
-- Records of thx_usergroup
-- ----------------------------
BEGIN;
INSERT INTO thx_usergroup VALUES ('1', '站点管理员', '-1', '0', '0', '0', '0', '1', '1', '0', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', '0', '0', '1', '1', '0', 'red', 'image/group/admin.gif', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', ''), ('2', '信息管理员', '-1', '0', '0', '0', '0', '1', '1', '0', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', '0', '0', '3', '1', '0', 'blue', 'image/group/infor.gif', '0', '0', '0', '0', '0', '1', '1', '1', '1', '1', '0', '1', '1', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ''), ('3', '贵宾VIP', '1', '0', '0', '0', '0', '1', '1', '0', '1', '0', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', '0', '0', '0', '0', '3', '0', '0', 'green', 'image/group/vip.gif', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ''), ('4', '受限会员', '0', '0', '-999999999', '10', '10', '0', '0', '600', '0', '300', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ''), ('5', '普通会员', '0', '0', '0', '100', '20', '0', '1', '60', '0', '60', '0', '0', '1', '1', '1', '1', '1', '1', '1', '0', '1', '1', '1', '1', '1', '1', '1', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ''), ('6', '中级会员', '0', '0', '100', '200', '50', '0', '1', '30', '0', '30', '0', '0', '1', '1', '1', '1', '1', '1', '1', '0', '1', '1', '1', '1', '1', '1', '1', '0', '1', '0', '0', '0', '0', '0', '5', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ''), ('7', '高级会员', '0', '0', '1000', '300', '100', '1', '1', '10', '1', '10', '0', '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', '1', '0', '0', '0', '0', '0', '3', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ''), ('8', '禁止发言', '-1', '0', '0', '1', '1', '0', '0', '9999', '0', '9999', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '99', '0', '1', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ''), ('9', '禁止访问', '-1', '1', '0', '1', '1', '0', '0', '9999', '0', '9999', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '99', '0', '1', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
COMMIT;

-- ----------------------------
-- Table structure for `thx_userlog`
-- ----------------------------
DROP TABLE IF EXISTS `thx_userlog`;
CREATE TABLE `thx_userlog` (
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`action`  char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`type`  tinyint(1) NOT NULL DEFAULT 0 ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`uid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_userlog
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_usermagic`
-- ----------------------------
DROP TABLE IF EXISTS `thx_usermagic`;
CREATE TABLE `thx_usermagic` (
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`mid`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`count`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`uid`, `mid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_usermagic
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_usertask`
-- ----------------------------
DROP TABLE IF EXISTS `thx_usertask`;
CREATE TABLE `thx_usertask` (
`uid`  mediumint(8) UNSIGNED NOT NULL ,
`username`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`taskid`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`credit`  smallint(6) NOT NULL DEFAULT 0 ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`isignore`  tinyint(1) NOT NULL DEFAULT 0 ,
PRIMARY KEY (`uid`, `taskid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_usertask
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thx_visitor`
-- ----------------------------
DROP TABLE IF EXISTS `thx_visitor`;
CREATE TABLE `thx_visitor` (
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`vuid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`vusername`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`uid`, `vuid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thx_visitor
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thxuc_admins`
-- ----------------------------
DROP TABLE IF EXISTS `thxuc_admins`;
CREATE TABLE `thxuc_admins` (
`uid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`username`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`allowadminsetting`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowadminapp`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowadminuser`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowadminbadword`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowadmintag`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowadminpm`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowadmincredits`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowadmindomain`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowadmindb`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowadminnote`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowadmincache`  tinyint(1) NOT NULL DEFAULT 0 ,
`allowadminlog`  tinyint(1) NOT NULL DEFAULT 0 ,
PRIMARY KEY (`uid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thxuc_admins
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thxuc_applications`
-- ----------------------------
DROP TABLE IF EXISTS `thxuc_applications`;
CREATE TABLE `thxuc_applications` (
`appid`  smallint(6) UNSIGNED NOT NULL AUTO_INCREMENT ,
`type`  char(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`name`  char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`url`  char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`authkey`  char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`ip`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`viewprourl`  char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`apifilename`  char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'uc.php' ,
`charset`  char(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`dbcharset`  char(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`synlogin`  tinyint(1) NOT NULL DEFAULT 0 ,
`recvnote`  tinyint(1) NULL DEFAULT 0 ,
`extra`  mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`tagtemplates`  mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`appid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=2

;

-- ----------------------------
-- Records of thxuc_applications
-- ----------------------------
BEGIN;
INSERT INTO thxuc_applications VALUES ('1', 'UCHOME', '个人家园', 'http://www.916178.com/thx', 'p971D7xft8E7c98bidp3J5k9IcD5E5QeX5j5J2Q1a4C9q1ybcaVbpdS7m2v232Mf', '', '', 'uc.php', 'utf-8', 'utf8', '1', '1', '', '<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\r\n<root>\r\n	<item id=\"template\"><![CDATA[<a href=\"{url}\" target=\"_blank\">{subject}</a>]]></item>\r\n	<item id=\"fields\">\r\n		<item id=\"subject\"><![CDATA[日志标题]]></item>\r\n		<item id=\"uid\"><![CDATA[用户 ID]]></item>\r\n		<item id=\"username\"><![CDATA[用户名]]></item>\r\n		<item id=\"dateline\"><![CDATA[日期]]></item>\r\n		<item id=\"spaceurl\"><![CDATA[空间地址]]></item>\r\n		<item id=\"url\"><![CDATA[日志地址]]></item>\r\n	</item>\r\n</root>');
COMMIT;

-- ----------------------------
-- Table structure for `thxuc_badwords`
-- ----------------------------
DROP TABLE IF EXISTS `thxuc_badwords`;
CREATE TABLE `thxuc_badwords` (
`id`  smallint(6) UNSIGNED NOT NULL AUTO_INCREMENT ,
`admin`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`find`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`replacement`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`findpattern`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thxuc_badwords
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thxuc_domains`
-- ----------------------------
DROP TABLE IF EXISTS `thxuc_domains`;
CREATE TABLE `thxuc_domains` (
`id`  int(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`domain`  char(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`ip`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thxuc_domains
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thxuc_failedlogins`
-- ----------------------------
DROP TABLE IF EXISTS `thxuc_failedlogins`;
CREATE TABLE `thxuc_failedlogins` (
`ip`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`count`  tinyint(1) UNSIGNED NOT NULL DEFAULT 0 ,
`lastupdate`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`ip`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thxuc_failedlogins
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thxuc_feeds`
-- ----------------------------
DROP TABLE IF EXISTS `thxuc_feeds`;
CREATE TABLE `thxuc_feeds` (
`feedid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`appid`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`icon`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`hash_template`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`hash_data`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`title_template`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`title_data`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`body_template`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`body_data`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`body_general`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`image_1`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`image_1_link`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`image_2`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`image_2_link`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`image_3`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`image_3_link`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`image_4`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`image_4_link`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`target_ids`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
PRIMARY KEY (`feedid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thxuc_feeds
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thxuc_friends`
-- ----------------------------
DROP TABLE IF EXISTS `thxuc_friends`;
CREATE TABLE `thxuc_friends` (
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`friendid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`direction`  tinyint(1) NOT NULL DEFAULT 0 ,
`version`  int(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`delstatus`  tinyint(1) NOT NULL DEFAULT 0 ,
`comment`  char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
PRIMARY KEY (`version`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thxuc_friends
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thxuc_mailqueue`
-- ----------------------------
DROP TABLE IF EXISTS `thxuc_mailqueue`;
CREATE TABLE `thxuc_mailqueue` (
`mailid`  int(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`touid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`tomail`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`frommail`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`subject`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`message`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`charset`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`htmlon`  tinyint(1) NOT NULL DEFAULT 0 ,
`level`  tinyint(1) NOT NULL DEFAULT 1 ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`failures`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 ,
`appid`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`mailid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thxuc_mailqueue
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thxuc_memberfields`
-- ----------------------------
DROP TABLE IF EXISTS `thxuc_memberfields`;
CREATE TABLE `thxuc_memberfields` (
`uid`  mediumint(8) UNSIGNED NOT NULL ,
`blacklist`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`uid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thxuc_memberfields
-- ----------------------------
BEGIN;
INSERT INTO thxuc_memberfields VALUES ('1', '');
COMMIT;

-- ----------------------------
-- Table structure for `thxuc_members`
-- ----------------------------
DROP TABLE IF EXISTS `thxuc_members`;
CREATE TABLE `thxuc_members` (
`uid`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`username`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`password`  char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`email`  char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`myid`  char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`myidkey`  char(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`regip`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`regdate`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`lastloginip`  int(10) NOT NULL DEFAULT 0 ,
`lastlogintime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`salt`  char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`secques`  char(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
PRIMARY KEY (`uid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=2

;

-- ----------------------------
-- Records of thxuc_members
-- ----------------------------
BEGIN;
INSERT INTO thxuc_members VALUES ('1', 'admin', '7e26ada2d9c0b260622f0f8689c63c82', 'webmastor@yourdomain.com', '', '', '113.108.110.50', '1302598782', '0', '0', 'ee8b25', '');
COMMIT;

-- ----------------------------
-- Table structure for `thxuc_mergemembers`
-- ----------------------------
DROP TABLE IF EXISTS `thxuc_mergemembers`;
CREATE TABLE `thxuc_mergemembers` (
`appid`  smallint(6) UNSIGNED NOT NULL ,
`username`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`appid`, `username`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thxuc_mergemembers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thxuc_newpm`
-- ----------------------------
DROP TABLE IF EXISTS `thxuc_newpm`;
CREATE TABLE `thxuc_newpm` (
`uid`  mediumint(8) UNSIGNED NOT NULL ,
PRIMARY KEY (`uid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thxuc_newpm
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thxuc_notelist`
-- ----------------------------
DROP TABLE IF EXISTS `thxuc_notelist`;
CREATE TABLE `thxuc_notelist` (
`noteid`  int(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`operation`  char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`closed`  tinyint(4) NOT NULL DEFAULT 0 ,
`totalnum`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`succeednum`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`getdata`  mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`postdata`  mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`pri`  tinyint(3) NOT NULL DEFAULT 0 ,
`app1`  tinyint(4) NOT NULL ,
PRIMARY KEY (`noteid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=2

;

-- ----------------------------
-- Records of thxuc_notelist
-- ----------------------------
BEGIN;
INSERT INTO thxuc_notelist VALUES ('1', 'updateapps', '1', '5', '0', '', '<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\r\n<root>\r\n	<item id=\"1\">\r\n		<item id=\"appid\"><![CDATA[1]]></item>\r\n		<item id=\"type\"><![CDATA[UCHOME]]></item>\r\n		<item id=\"name\"><![CDATA[个人家园]]></item>\r\n		<item id=\"url\"><![CDATA[http://www.916178.com/thx]]></item>\r\n		<item id=\"ip\"><![CDATA[]]></item>\r\n		<item id=\"charset\"><![CDATA[utf-8]]></item>\r\n		<item id=\"synlogin\"><![CDATA[1]]></item>\r\n		<item id=\"extra\"><![CDATA[]]></item>\r\n	</item>\r\n	<item id=\"UC_API\"><![CDATA[http://www.916178.com/thx/center]]></item>\r\n</root>', '1302601860', '0', '-5');
COMMIT;

-- ----------------------------
-- Table structure for `thxuc_pms`
-- ----------------------------
DROP TABLE IF EXISTS `thxuc_pms`;
CREATE TABLE `thxuc_pms` (
`pmid`  int(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`msgfrom`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`msgfromid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`msgtoid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`folder`  enum('inbox','outbox') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'inbox' ,
`new`  tinyint(1) NOT NULL DEFAULT 0 ,
`subject`  varchar(75) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`message`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`delstatus`  tinyint(1) UNSIGNED NOT NULL DEFAULT 0 ,
`related`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`fromappid`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`pmid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of thxuc_pms
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thxuc_protectedmembers`
-- ----------------------------
DROP TABLE IF EXISTS `thxuc_protectedmembers`;
CREATE TABLE `thxuc_protectedmembers` (
`uid`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`username`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`appid`  tinyint(1) UNSIGNED NOT NULL DEFAULT 0 ,
`dateline`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`admin`  char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thxuc_protectedmembers
-- ----------------------------
BEGIN;
INSERT INTO thxuc_protectedmembers VALUES ('1', 'admin', '1', '1302598782', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for `thxuc_settings`
-- ----------------------------
DROP TABLE IF EXISTS `thxuc_settings`;
CREATE TABLE `thxuc_settings` (
`k`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`v`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`k`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thxuc_settings
-- ----------------------------
BEGIN;
INSERT INTO thxuc_settings VALUES ('accessemail', ''), ('censoremail', ''), ('censorusername', ''), ('dateformat', 'y-n-j'), ('doublee', '1'), ('nextnotetime', '0'), ('timeoffset', '28800'), ('pmlimit1day', '100'), ('pmuserlimit1day', '30'), ('pmfloodctrl', '15'), ('pmcenter', '1'), ('sendpmseccode', '1'), ('pmsendregdays', '0'), ('maildefault', 'username@21cn.com'), ('mailsend', '1'), ('mailserver', 'smtp.21cn.com'), ('mailport', '25'), ('mailauth', '1'), ('mailfrom', 'UCenter <username@21cn.com>'), ('mailauth_username', 'username@21cn.com'), ('mailauth_password', 'password'), ('maildelimiter', '0'), ('mailusername', '1'), ('mailsilent', '1'), ('version', '1.5.0');
COMMIT;

-- ----------------------------
-- Table structure for `thxuc_sqlcache`
-- ----------------------------
DROP TABLE IF EXISTS `thxuc_sqlcache`;
CREATE TABLE `thxuc_sqlcache` (
`sqlid`  char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`data`  char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`expiry`  int(10) UNSIGNED NOT NULL ,
PRIMARY KEY (`sqlid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thxuc_sqlcache
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thxuc_tags`
-- ----------------------------
DROP TABLE IF EXISTS `thxuc_tags`;
CREATE TABLE `thxuc_tags` (
`tagname`  char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`appid`  smallint(6) UNSIGNED NOT NULL DEFAULT 0 ,
`data`  mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`expiration`  int(10) UNSIGNED NOT NULL 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thxuc_tags
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `thxuc_vars`
-- ----------------------------
DROP TABLE IF EXISTS `thxuc_vars`;
CREATE TABLE `thxuc_vars` (
`name`  char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`value`  char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
PRIMARY KEY (`name`)
)
ENGINE=MEMORY
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of thxuc_vars
-- ----------------------------
BEGIN;
INSERT INTO thxuc_vars VALUES ('noteexists', '1'), ('noteexists1', '0');
COMMIT;

-- ----------------------------
-- Auto increment value for `thx_ad`
-- ----------------------------
ALTER TABLE `thx_ad` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thx_album`
-- ----------------------------
CREATE INDEX `uid` USING BTREE ON `thx_album`(`uid`, `updatetime`);
CREATE INDEX `updatetime` USING BTREE ON `thx_album`(`updatetime`);

-- ----------------------------
-- Auto increment value for `thx_album`
-- ----------------------------
ALTER TABLE `thx_album` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thx_appcreditlog`
-- ----------------------------
CREATE INDEX `uid` USING BTREE ON `thx_appcreditlog`(`uid`, `dateline`);
CREATE INDEX `appid` USING BTREE ON `thx_appcreditlog`(`appid`);

-- ----------------------------
-- Auto increment value for `thx_appcreditlog`
-- ----------------------------
ALTER TABLE `thx_appcreditlog` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thx_blacklist`
-- ----------------------------
CREATE INDEX `uid` USING BTREE ON `thx_blacklist`(`uid`, `dateline`);

-- ----------------------------
-- Auto increment value for `thx_block`
-- ----------------------------
ALTER TABLE `thx_block` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thx_blog`
-- ----------------------------
CREATE INDEX `uid` USING BTREE ON `thx_blog`(`uid`, `dateline`);
CREATE INDEX `topicid` USING BTREE ON `thx_blog`(`topicid`, `dateline`);
CREATE INDEX `dateline` USING BTREE ON `thx_blog`(`dateline`);

-- ----------------------------
-- Auto increment value for `thx_blog`
-- ----------------------------
ALTER TABLE `thx_blog` AUTO_INCREMENT=17;

-- ----------------------------
-- Indexes structure for table `thx_class`
-- ----------------------------
CREATE INDEX `uid` USING BTREE ON `thx_class`(`uid`);

-- ----------------------------
-- Auto increment value for `thx_class`
-- ----------------------------
ALTER TABLE `thx_class` AUTO_INCREMENT=5;

-- ----------------------------
-- Indexes structure for table `thx_click`
-- ----------------------------
CREATE INDEX `idtype` USING BTREE ON `thx_click`(`idtype`, `displayorder`);

-- ----------------------------
-- Auto increment value for `thx_click`
-- ----------------------------
ALTER TABLE `thx_click` AUTO_INCREMENT=16;

-- ----------------------------
-- Indexes structure for table `thx_clickuser`
-- ----------------------------
CREATE INDEX `id` USING BTREE ON `thx_clickuser`(`id`, `idtype`, `dateline`);
CREATE INDEX `uid` USING BTREE ON `thx_clickuser`(`uid`, `idtype`, `dateline`);

-- ----------------------------
-- Indexes structure for table `thx_comment`
-- ----------------------------
CREATE INDEX `authorid` USING BTREE ON `thx_comment`(`authorid`, `idtype`);
CREATE INDEX `id` USING BTREE ON `thx_comment`(`id`, `idtype`, `dateline`);

-- ----------------------------
-- Auto increment value for `thx_comment`
-- ----------------------------
ALTER TABLE `thx_comment` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thx_creditlog`
-- ----------------------------
CREATE INDEX `uid` USING BTREE ON `thx_creditlog`(`uid`, `rid`);
CREATE INDEX `dateline` USING BTREE ON `thx_creditlog`(`dateline`);

-- ----------------------------
-- Auto increment value for `thx_creditlog`
-- ----------------------------
ALTER TABLE `thx_creditlog` AUTO_INCREMENT=5;

-- ----------------------------
-- Indexes structure for table `thx_creditrule`
-- ----------------------------
CREATE INDEX `action` USING BTREE ON `thx_creditrule`(`action`);

-- ----------------------------
-- Auto increment value for `thx_creditrule`
-- ----------------------------
ALTER TABLE `thx_creditrule` AUTO_INCREMENT=48;

-- ----------------------------
-- Indexes structure for table `thx_cron`
-- ----------------------------
CREATE INDEX `nextrun` USING BTREE ON `thx_cron`(`available`, `nextrun`);

-- ----------------------------
-- Auto increment value for `thx_cron`
-- ----------------------------
ALTER TABLE `thx_cron` AUTO_INCREMENT=6;

-- ----------------------------
-- Indexes structure for table `thx_docomment`
-- ----------------------------
CREATE INDEX `doid` USING BTREE ON `thx_docomment`(`doid`, `dateline`);
CREATE INDEX `dateline` USING BTREE ON `thx_docomment`(`dateline`);

-- ----------------------------
-- Auto increment value for `thx_docomment`
-- ----------------------------
ALTER TABLE `thx_docomment` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thx_doing`
-- ----------------------------
CREATE INDEX `uid` USING BTREE ON `thx_doing`(`uid`, `dateline`);
CREATE INDEX `dateline` USING BTREE ON `thx_doing`(`dateline`);

-- ----------------------------
-- Auto increment value for `thx_doing`
-- ----------------------------
ALTER TABLE `thx_doing` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thx_event`
-- ----------------------------
CREATE INDEX `grade` USING BTREE ON `thx_event`(`grade`, `recommendtime`);
CREATE INDEX `membernum` USING BTREE ON `thx_event`(`membernum`);
CREATE INDEX `uid` USING BTREE ON `thx_event`(`uid`, `eventid`);
CREATE INDEX `tagid` USING BTREE ON `thx_event`(`tagid`, `eventid`);
CREATE INDEX `topicid` USING BTREE ON `thx_event`(`topicid`, `dateline`);

-- ----------------------------
-- Auto increment value for `thx_event`
-- ----------------------------
ALTER TABLE `thx_event` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thx_eventclass`
-- ----------------------------
CREATE UNIQUE INDEX `classname` USING BTREE ON `thx_eventclass`(`classname`);

-- ----------------------------
-- Auto increment value for `thx_eventclass`
-- ----------------------------
ALTER TABLE `thx_eventclass` AUTO_INCREMENT=7;

-- ----------------------------
-- Auto increment value for `thx_eventfield`
-- ----------------------------
ALTER TABLE `thx_eventfield` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thx_eventpic`
-- ----------------------------
CREATE INDEX `eventid` USING BTREE ON `thx_eventpic`(`eventid`, `picid`);

-- ----------------------------
-- Indexes structure for table `thx_feed`
-- ----------------------------
CREATE INDEX `uid` USING BTREE ON `thx_feed`(`uid`, `dateline`);
CREATE INDEX `dateline` USING BTREE ON `thx_feed`(`dateline`);
CREATE INDEX `hot` USING BTREE ON `thx_feed`(`hot`);
CREATE INDEX `id` USING BTREE ON `thx_feed`(`id`, `idtype`);

-- ----------------------------
-- Auto increment value for `thx_feed`
-- ----------------------------
ALTER TABLE `thx_feed` AUTO_INCREMENT=4;

-- ----------------------------
-- Indexes structure for table `thx_friend`
-- ----------------------------
CREATE INDEX `fuid` USING BTREE ON `thx_friend`(`fuid`);
CREATE INDEX `status` USING BTREE ON `thx_friend`(`uid`, `status`, `num`, `dateline`);

-- ----------------------------
-- Indexes structure for table `thx_friendguide`
-- ----------------------------
CREATE INDEX `uid` USING BTREE ON `thx_friendguide`(`uid`, `num`);

-- ----------------------------
-- Indexes structure for table `thx_invite`
-- ----------------------------
CREATE INDEX `uid` USING BTREE ON `thx_invite`(`uid`);

-- ----------------------------
-- Auto increment value for `thx_invite`
-- ----------------------------
ALTER TABLE `thx_invite` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for `thx_log`
-- ----------------------------
ALTER TABLE `thx_log` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thx_magicinlog`
-- ----------------------------
CREATE INDEX `uid` USING BTREE ON `thx_magicinlog`(`uid`, `dateline`);
CREATE INDEX `type` USING BTREE ON `thx_magicinlog`(`type`, `fromid`, `dateline`);

-- ----------------------------
-- Auto increment value for `thx_magicinlog`
-- ----------------------------
ALTER TABLE `thx_magicinlog` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thx_magicuselog`
-- ----------------------------
CREATE INDEX `uid` USING BTREE ON `thx_magicuselog`(`uid`, `mid`);
CREATE INDEX `id` USING BTREE ON `thx_magicuselog`(`id`, `idtype`);

-- ----------------------------
-- Auto increment value for `thx_magicuselog`
-- ----------------------------
ALTER TABLE `thx_magicuselog` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thx_mailcron`
-- ----------------------------
CREATE INDEX `sendtime` USING BTREE ON `thx_mailcron`(`sendtime`);

-- ----------------------------
-- Auto increment value for `thx_mailcron`
-- ----------------------------
ALTER TABLE `thx_mailcron` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thx_mailqueue`
-- ----------------------------
CREATE INDEX `mcid` USING BTREE ON `thx_mailqueue`(`cid`, `dateline`);

-- ----------------------------
-- Auto increment value for `thx_mailqueue`
-- ----------------------------
ALTER TABLE `thx_mailqueue` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for `thx_member`
-- ----------------------------
ALTER TABLE `thx_member` AUTO_INCREMENT=2;

-- ----------------------------
-- Indexes structure for table `thx_mtag`
-- ----------------------------
CREATE INDEX `tagname` USING BTREE ON `thx_mtag`(`tagname`);
CREATE INDEX `threadnum` USING BTREE ON `thx_mtag`(`threadnum`);

-- ----------------------------
-- Auto increment value for `thx_mtag`
-- ----------------------------
ALTER TABLE `thx_mtag` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thx_myapp`
-- ----------------------------
CREATE INDEX `flag` USING BTREE ON `thx_myapp`(`flag`, `displayorder`);

-- ----------------------------
-- Indexes structure for table `thx_myinvite`
-- ----------------------------
CREATE INDEX `hash` USING BTREE ON `thx_myinvite`(`hash`);
CREATE INDEX `uid` USING BTREE ON `thx_myinvite`(`touid`, `dateline`);

-- ----------------------------
-- Auto increment value for `thx_myinvite`
-- ----------------------------
ALTER TABLE `thx_myinvite` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thx_notification`
-- ----------------------------
CREATE INDEX `uid` USING BTREE ON `thx_notification`(`uid`, `new`, `dateline`);

-- ----------------------------
-- Auto increment value for `thx_notification`
-- ----------------------------
ALTER TABLE `thx_notification` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thx_pic`
-- ----------------------------
CREATE INDEX `albumid` USING BTREE ON `thx_pic`(`albumid`, `dateline`);
CREATE INDEX `topicid` USING BTREE ON `thx_pic`(`topicid`, `dateline`);

-- ----------------------------
-- Auto increment value for `thx_pic`
-- ----------------------------
ALTER TABLE `thx_pic` AUTO_INCREMENT=2;

-- ----------------------------
-- Indexes structure for table `thx_poke`
-- ----------------------------
CREATE INDEX `uid` USING BTREE ON `thx_poke`(`uid`, `dateline`);

-- ----------------------------
-- Indexes structure for table `thx_poll`
-- ----------------------------
CREATE INDEX `uid` USING BTREE ON `thx_poll`(`uid`, `dateline`);
CREATE INDEX `topicid` USING BTREE ON `thx_poll`(`topicid`, `dateline`);
CREATE INDEX `voternum` USING BTREE ON `thx_poll`(`voternum`);
CREATE INDEX `dateline` USING BTREE ON `thx_poll`(`dateline`);
CREATE INDEX `lastvote` USING BTREE ON `thx_poll`(`lastvote`);
CREATE INDEX `hot` USING BTREE ON `thx_poll`(`hot`);
CREATE INDEX `percredit` USING BTREE ON `thx_poll`(`percredit`);

-- ----------------------------
-- Auto increment value for `thx_poll`
-- ----------------------------
ALTER TABLE `thx_poll` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thx_polloption`
-- ----------------------------
CREATE INDEX `pid` USING BTREE ON `thx_polloption`(`pid`);

-- ----------------------------
-- Auto increment value for `thx_polloption`
-- ----------------------------
ALTER TABLE `thx_polloption` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thx_polluser`
-- ----------------------------
CREATE INDEX `pid` USING BTREE ON `thx_polluser`(`pid`, `dateline`);
CREATE INDEX `uid` USING BTREE ON `thx_polluser`(`uid`, `dateline`);

-- ----------------------------
-- Indexes structure for table `thx_post`
-- ----------------------------
CREATE INDEX `tid` USING BTREE ON `thx_post`(`tid`, `dateline`);

-- ----------------------------
-- Auto increment value for `thx_post`
-- ----------------------------
ALTER TABLE `thx_post` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for `thx_product`
-- ----------------------------
ALTER TABLE `thx_product` AUTO_INCREMENT=34;

-- ----------------------------
-- Auto increment value for `thx_profield`
-- ----------------------------
ALTER TABLE `thx_profield` AUTO_INCREMENT=4;

-- ----------------------------
-- Auto increment value for `thx_profilefield`
-- ----------------------------
ALTER TABLE `thx_profilefield` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thx_report`
-- ----------------------------
CREATE INDEX `id` USING BTREE ON `thx_report`(`id`, `idtype`, `num`, `dateline`);
CREATE INDEX `new` USING BTREE ON `thx_report`(`new`, `dateline`);

-- ----------------------------
-- Auto increment value for `thx_report`
-- ----------------------------
ALTER TABLE `thx_report` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thx_session`
-- ----------------------------
CREATE INDEX `lastactivity` USING HASH ON `thx_session`(`lastactivity`);
CREATE INDEX `ip` USING HASH ON `thx_session`(`ip`);

-- ----------------------------
-- Indexes structure for table `thx_share`
-- ----------------------------
CREATE INDEX `uid` USING BTREE ON `thx_share`(`uid`, `dateline`);
CREATE INDEX `topicid` USING BTREE ON `thx_share`(`topicid`, `dateline`);
CREATE INDEX `hot` USING BTREE ON `thx_share`(`hot`);
CREATE INDEX `dateline` USING BTREE ON `thx_share`(`dateline`);

-- ----------------------------
-- Auto increment value for `thx_share`
-- ----------------------------
ALTER TABLE `thx_share` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thx_show`
-- ----------------------------
CREATE INDEX `credit` USING BTREE ON `thx_show`(`credit`);

-- ----------------------------
-- Indexes structure for table `thx_space`
-- ----------------------------
CREATE INDEX `username` USING BTREE ON `thx_space`(`username`);
CREATE INDEX `domain` USING BTREE ON `thx_space`(`domain`);
CREATE INDEX `ip` USING BTREE ON `thx_space`(`ip`);
CREATE INDEX `updatetime` USING BTREE ON `thx_space`(`updatetime`);
CREATE INDEX `mood` USING BTREE ON `thx_space`(`mood`);

-- ----------------------------
-- Indexes structure for table `thx_spaceinfo`
-- ----------------------------
CREATE INDEX `uid` USING BTREE ON `thx_spaceinfo`(`uid`);

-- ----------------------------
-- Auto increment value for `thx_spaceinfo`
-- ----------------------------
ALTER TABLE `thx_spaceinfo` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thx_spacelog`
-- ----------------------------
CREATE INDEX `flag` USING BTREE ON `thx_spacelog`(`flag`);

-- ----------------------------
-- Indexes structure for table `thx_statuser`
-- ----------------------------
CREATE INDEX `uid` USING BTREE ON `thx_statuser`(`uid`);

-- ----------------------------
-- Indexes structure for table `thx_tag`
-- ----------------------------
CREATE INDEX `tagname` USING BTREE ON `thx_tag`(`tagname`);

-- ----------------------------
-- Auto increment value for `thx_tag`
-- ----------------------------
ALTER TABLE `thx_tag` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thx_tagspace`
-- ----------------------------
CREATE INDEX `grade` USING BTREE ON `thx_tagspace`(`tagid`, `grade`);
CREATE INDEX `uid` USING BTREE ON `thx_tagspace`(`uid`, `grade`);

-- ----------------------------
-- Indexes structure for table `thx_task`
-- ----------------------------
CREATE INDEX `displayorder` USING BTREE ON `thx_task`(`displayorder`);

-- ----------------------------
-- Auto increment value for `thx_task`
-- ----------------------------
ALTER TABLE `thx_task` AUTO_INCREMENT=8;

-- ----------------------------
-- Indexes structure for table `thx_thread`
-- ----------------------------
CREATE INDEX `tagid` USING BTREE ON `thx_thread`(`tagid`, `displayorder`, `lastpost`);
CREATE INDEX `uid` USING BTREE ON `thx_thread`(`uid`, `lastpost`);
CREATE INDEX `lastpost` USING BTREE ON `thx_thread`(`lastpost`);
CREATE INDEX `topicid` USING BTREE ON `thx_thread`(`topicid`, `dateline`);
CREATE INDEX `eventid` USING BTREE ON `thx_thread`(`eventid`, `lastpost`);

-- ----------------------------
-- Auto increment value for `thx_thread`
-- ----------------------------
ALTER TABLE `thx_thread` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thx_topic`
-- ----------------------------
CREATE INDEX `lastpost` USING BTREE ON `thx_topic`(`lastpost`);
CREATE INDEX `joinnum` USING BTREE ON `thx_topic`(`joinnum`);

-- ----------------------------
-- Auto increment value for `thx_topic`
-- ----------------------------
ALTER TABLE `thx_topic` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thx_topicuser`
-- ----------------------------
CREATE INDEX `uid` USING BTREE ON `thx_topicuser`(`uid`, `dateline`);
CREATE INDEX `topicid` USING BTREE ON `thx_topicuser`(`topicid`, `dateline`);

-- ----------------------------
-- Auto increment value for `thx_topicuser`
-- ----------------------------
ALTER TABLE `thx_topicuser` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thx_userapp`
-- ----------------------------
CREATE INDEX `uid` USING BTREE ON `thx_userapp`(`uid`, `appid`);
CREATE INDEX `menuorder` USING BTREE ON `thx_userapp`(`uid`, `menuorder`);
CREATE INDEX `displayorder` USING BTREE ON `thx_userapp`(`uid`, `displayorder`);

-- ----------------------------
-- Indexes structure for table `thx_userappfield`
-- ----------------------------
CREATE INDEX `uid` USING BTREE ON `thx_userappfield`(`uid`, `appid`);

-- ----------------------------
-- Indexes structure for table `thx_userevent`
-- ----------------------------
CREATE INDEX `uid` USING BTREE ON `thx_userevent`(`uid`, `dateline`);
CREATE INDEX `eventid` USING BTREE ON `thx_userevent`(`eventid`, `status`, `dateline`);

-- ----------------------------
-- Auto increment value for `thx_usergroup`
-- ----------------------------
ALTER TABLE `thx_usergroup` AUTO_INCREMENT=10;

-- ----------------------------
-- Indexes structure for table `thx_usertask`
-- ----------------------------
CREATE INDEX `isignore` USING BTREE ON `thx_usertask`(`isignore`, `dateline`);

-- ----------------------------
-- Indexes structure for table `thx_visitor`
-- ----------------------------
CREATE INDEX `dateline` USING BTREE ON `thx_visitor`(`uid`, `dateline`);

-- ----------------------------
-- Indexes structure for table `thxuc_admins`
-- ----------------------------
CREATE UNIQUE INDEX `username` USING BTREE ON `thxuc_admins`(`username`);

-- ----------------------------
-- Auto increment value for `thxuc_admins`
-- ----------------------------
ALTER TABLE `thxuc_admins` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for `thxuc_applications`
-- ----------------------------
ALTER TABLE `thxuc_applications` AUTO_INCREMENT=2;

-- ----------------------------
-- Indexes structure for table `thxuc_badwords`
-- ----------------------------
CREATE UNIQUE INDEX `find` USING BTREE ON `thxuc_badwords`(`find`);

-- ----------------------------
-- Auto increment value for `thxuc_badwords`
-- ----------------------------
ALTER TABLE `thxuc_badwords` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for `thxuc_domains`
-- ----------------------------
ALTER TABLE `thxuc_domains` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thxuc_feeds`
-- ----------------------------
CREATE INDEX `uid` USING BTREE ON `thxuc_feeds`(`uid`, `dateline`);

-- ----------------------------
-- Auto increment value for `thxuc_feeds`
-- ----------------------------
ALTER TABLE `thxuc_feeds` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thxuc_friends`
-- ----------------------------
CREATE INDEX `uid` USING BTREE ON `thxuc_friends`(`uid`);
CREATE INDEX `friendid` USING BTREE ON `thxuc_friends`(`friendid`);

-- ----------------------------
-- Auto increment value for `thxuc_friends`
-- ----------------------------
ALTER TABLE `thxuc_friends` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thxuc_mailqueue`
-- ----------------------------
CREATE INDEX `appid` USING BTREE ON `thxuc_mailqueue`(`appid`);
CREATE INDEX `level` USING BTREE ON `thxuc_mailqueue`(`level`, `failures`);

-- ----------------------------
-- Auto increment value for `thxuc_mailqueue`
-- ----------------------------
ALTER TABLE `thxuc_mailqueue` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thxuc_members`
-- ----------------------------
CREATE UNIQUE INDEX `username` USING BTREE ON `thxuc_members`(`username`);
CREATE INDEX `email` USING BTREE ON `thxuc_members`(`email`);

-- ----------------------------
-- Auto increment value for `thxuc_members`
-- ----------------------------
ALTER TABLE `thxuc_members` AUTO_INCREMENT=2;

-- ----------------------------
-- Indexes structure for table `thxuc_notelist`
-- ----------------------------
CREATE INDEX `closed` USING BTREE ON `thxuc_notelist`(`closed`, `pri`, `noteid`);
CREATE INDEX `dateline` USING BTREE ON `thxuc_notelist`(`dateline`);

-- ----------------------------
-- Auto increment value for `thxuc_notelist`
-- ----------------------------
ALTER TABLE `thxuc_notelist` AUTO_INCREMENT=2;

-- ----------------------------
-- Indexes structure for table `thxuc_pms`
-- ----------------------------
CREATE INDEX `msgtoid` USING BTREE ON `thxuc_pms`(`msgtoid`, `folder`, `dateline`);
CREATE INDEX `msgfromid` USING BTREE ON `thxuc_pms`(`msgfromid`, `folder`, `dateline`);
CREATE INDEX `related` USING BTREE ON `thxuc_pms`(`related`);
CREATE INDEX `getnum` USING BTREE ON `thxuc_pms`(`msgtoid`, `folder`, `delstatus`);

-- ----------------------------
-- Auto increment value for `thxuc_pms`
-- ----------------------------
ALTER TABLE `thxuc_pms` AUTO_INCREMENT=1;

-- ----------------------------
-- Indexes structure for table `thxuc_protectedmembers`
-- ----------------------------
CREATE UNIQUE INDEX `username` USING BTREE ON `thxuc_protectedmembers`(`username`, `appid`);

-- ----------------------------
-- Indexes structure for table `thxuc_sqlcache`
-- ----------------------------
CREATE INDEX `expiry` USING BTREE ON `thxuc_sqlcache`(`expiry`);

-- ----------------------------
-- Indexes structure for table `thxuc_tags`
-- ----------------------------
CREATE INDEX `tagname` USING BTREE ON `thxuc_tags`(`tagname`, `appid`);
